You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Concatenate using EVALUATE_AGGR('SYS.STRAGG(DISTINCT)

Received Response
51
Views
9
Comments
edited Jun 21, 2017 8:56PM in Reporting and Analytics Taleo Enterprise 9 comments

Summary

Need to Concatenate Multiple Rows Job Titles into 1 Row

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!