Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to concatenate

nmotiani
7 - Meteor

if one contact has multiple products how to concatenate in alteryx. Please help me build a workflow

 

for example:

 

ContactProduct
Contact 1Apple
Contact 2Apple
Contact 1Orange
Contact 3Apple
Contact 1Kiwi
Contact 3Kiwi
Contact 4Apple

 

Desired Output:

ContactAll Products
Contact 1Apple, Orange Kiwi
Contact 2Apple
Contact 3Apple, Kiwi
Contact 4Apple
4 REPLIES 4
JosephSerpis
17 - Castor
17 - Castor

Hi @nmotiani you can use the Summarise tool to concatenate. 

Screenshot 2025-10-06 151119.png

alexnajm
18 - Pollux
18 - Pollux

100% agreed with @JosephSerpis ^

aatalai
15 - Aurora

agree with @JosephSerpis but might add a sort after the summarise to have the data in order

dreldrel
9 - Comet

Just a small thing to add on - in the summarise tool, you can specify the delimiter at the bottom of the config window

Labels
Top Solution Authors