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
User | Count |
---|---|
107 | |
82 | |
69 | |
54 | |
40 |