Grouping data into a comma-separated string

Bowenaus

09-09-2020

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
1mukeshgupta2Leadership
3neelamsharma3Hard-working
1mukeshgupta2Responsible
2deveshtyagi2Punctuality
3neelamsharma3Self-motivated
1mukeshgupta2Quick-learner
4keshavsinghal3Listening
2deveshtyagi2Quick-learner
5tanyajain1Hard-working
4keshavsinghal3Critical thinking
5tanyajain1Goal-oriented

Queries:

  1. 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-learner
    2deveshtyagi2Punctuality, Quick-learner
    3neelamsharma3Hard-working, Self-motivated
    4keshavsinghal3Listening, Critical thinking
    5tanyajain1Hard-working, Goal-oriented
 

If anyone has any ideas on how to apply this logic using the targeting activities available in Adobe Campaign Classic, please let me know!

 

Source: https://www.geeksforgeeks.org/mysql-group_concat-function/#:~:text=The%20GROUP_CONCAT()%20function%2....

 

Thanks!

Austin B.

Accepted Solutions (1)

Accepted Solutions (1)

DavidKangni

MVP

09-09-2020

Hi Austin,

 

You can try Adding additional SQL functions 

 

Thanks,

David

Answers (0)