if one contact has multiple products how to concatenate in alteryx. Please help me build a workflow
for example:
| Contact | Product |
| Contact 1 | Apple |
| Contact 2 | Apple |
| Contact 1 | Orange |
| Contact 3 | Apple |
| Contact 1 | Kiwi |
| Contact 3 | Kiwi |
| Contact 4 | Apple |
Desired Output:
| Contact | All Products |
| Contact 1 | Apple, Orange Kiwi |
| Contact 2 | Apple |
| Contact 3 | Apple, Kiwi |
| Contact 4 | Apple |
Hi @nmotiani you can use the Summarise tool to concatenate.
100% agreed with @JosephSerpis ^
agree with @JosephSerpis but might add a sort after the summarise to have the data in order
Just a small thing to add on - in the summarise tool, you can specify the delimiter at the bottom of the config window
