For more information, please refer to this announcement explaining best practices for getting answers to questions.
Concatenate a case statement with fields
Summary
I want to concatenate a case statement with a field in OTBI. How would i do so?Content
"Worker"."Person Type",
CASE
WHEN ( "Assignment Manager List Unsecured"."Manager Flag Code" = 'Y' ) THEN
COUNT(DISTINCT "Assignment Manager (Unsecured)"."Person name1")
ELSE
null
END
FROM
"Workforce Management - Worker Assignment Real Time"
I want to transform the above and concatenate the person type and count person name 1.
example:
CASE
WHEN ( "Assignment Manager List Unsecured"."Manager Flag Code" = 'Y' ) THEN
"Worker"."Person Type" || ',' || COUNT(DISTINCT "Assignment Manager (Unsecured)"."Person name1")
ELSE
null
END
FROM
"Workforce Management - Worker Assignment Real Time"