Hi,
I have below two tables, would like to look up for the ID and then join the multiple values using ";". Is this achieve in alteryx?
Thanks in Advance.
Table 1
ID | Value |
29 | Apple |
29 | Pear |
29 | Orange |
30 | Banana |
30 | Kiwi |
30 | Pineapple |
Table 2
Row | ID | ID |
A | 29 | 30 |
Desired Output
Row | ID | ID |
A | Apple;Pear;Orange | Banana;Kiwi;Pineapple |
Solved! Go to Solution.
Hi @CY712 ,
Here is a workflow for the task.
Input: tables given by you.
Output:
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Works perfectly. Thanks!
Happy to help 🙂
Cheers and happy analyzing 😀