- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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:
| 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!
Thanks!
Austin B.
Solved! Go to Solution.
Views
Replies
0 Likes
Total Likes