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 1 | mukesh | gupta | 2 | Leadership |
3 | neelam | sharma | 3 | Hard-working |
1 | mukesh | gupta | 2 | Responsible |
2 | devesh | tyagi | 2 | Punctuality |
3 | neelam | sharma | 3 | Self-motivated |
1 | mukesh | gupta | 2 | Quick-learner |
4 | keshav | singhal | 3 | Listening |
2 | devesh | tyagi | 2 | Quick-learner |
5 | tanya | jain | 1 | Hard-working |
4 | keshav | singhal | 3 | Critical thinking |
5 | tanya | jain | 1 | Goal-oriented |
Queries:
- 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 1 | mukesh | gupta | 2 | Leadership, Resposible, Quick-learner |
2 | devesh | tyagi | 2 | Punctuality, Quick-learner |
3 | neelam | sharma | 3 | Hard-working, Self-motivated |
4 | keshav | singhal | 3 | Listening, Critical thinking |
5 | tanya | jain | 1 | Hard-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.