Grouping data into a comma-separated string Hello, We have a need for a workflow which is capable of replicating the Group_CONCAT() function in SQL. All of the "Group By" options I've seen in Adobe Campaign are just capable of aggregating #s together but I can't find anything which can concatenate strings into a comma-separated string like this example: EMP_ID FNAME LNAME DEPT_ID STRENGTH 1mukeshgupta2Leadership3neelamsharma3Hard-working1mukeshgupta2Responsible2deveshtyagi2Punctuality3neelamsharma3Self-motivated1mukeshgupta2Quick-learner4keshavsinghal3Listening2deveshtyagi2Quick-learner5tanyajain1Hard-working4keshavsinghal3Critical thinking5tanyajain1Goal-orientedQueries:Using simple GROUP_CONCAT() function-SELECT emp_id, fname, lname, dept_id,
GROUP_CONCAT ( strength ) as "strengths"
FROM employee group by emp_id;Output:EMP_ID FNAME LNAME DEPT_ID STRENGTHS 1mukeshgupta2Leadership, Resposible, Quick-learner2deveshtyagi2Punctuality, Quick-learner3neelamsharma3Hard-working, Self-motivated4keshavsinghal3