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
 
					
				
				
			
		
