


Hello,
We have a need for a workflow which is capable of replicating the Group_CONCAT() function in SQL.
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:
SELECT emp_id, fname, lname, dept_id, GROUP_CONCAT ( strength ) as "strengths" FROM employee group by emp_id;
Output:
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!
Thanks!
Austin B.
Views
Replies
Sign in to like this content
Total Likes