Concatenate using EVALUATE_AGGR('SYS.STRAGG(DISTINCT)

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