Get Started with Redwood for Oracle Cloud HCM Begin Now
Combine Multiple Rows
Summary
How do I combine multiple rows for a person into one row?Content
We have a report that pulls in our terminations for the day. There are some employees that are showing up with a Person Type = Dependent and Person Type = Ex-employee, so they have two rows. Is there a formula I can use to combine into one? I tried using this formula (from my OBIEE report writing library) and it is not working. Thoughts?
LEFT(EVALUATE_AGGR('SYS.STRAGG(DISTINCT(%1||%2))' AS CHARACTER(1000),"Workforce Management - Person Real Time"."Person Type"."Person Type",', '), CHAR_LENGTH(EVALUATE_AGGR('SYS.STRAGG(DISTINCT(%1||%2))' AS CHARACTER(1000),"Workforce Management - Person Real Time"."Person Type"."Person Type",', ')) -2)
Tagged:
0