Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Concatenate using EVALUATE_AGGR('SYS.STRAGG(DISTINCT)
Summary
Need to Concatenate Multiple Rows Job Titles into 1 RowContent
I need to concatenate 5 multiple rows into 1 row and 1 column separated by a #
Final Output
Candidate Identified Submission Experience Job Title (Other)
10000 Sr Rroject Engr #Engr IV #Machine Engr#Specialist#Operator
Got error using this-
TRIM(TRAILING ',' FROM EVALUATE_AGGR('SYS.STRAGG(DISTINCT(%1 || %2 || %3|| %4|| %5))' AS CHARACTER(1000), "Submission Work Experience History"."Submission Experience Job Title (Other)", '#'))
Data
| Candidate Identifier | Submission Experience Job Title (Other) | RANK(Submission Experience Start Date) |
| 10000 | Sr Project Engr | 1 |
| 10000 | Engr IV | 2 |
| 10000 | Machine Engr | 3 |
| 10000 | Specialist | 4 |
| 10000 |
Operator |
5 |
0