TEXTJOIN like function conditional concatenate

daavvt

Hi- I am fairly new to Alteryx. 

In Excel, I would use TEXTJOIN as an array function to conditionally return all the entries that matched the criteria. (See: https://www.howtoexcel.org/formulas/how-to-conditionally-concatenate-a-range-formula/)

Is there a way to do this in Alteryx? I am looking to create a readout that displays all the products billed to a client, so my source sheet might have a client ID, then many entries with that id with different product names, and I want to put them all into a single cell (preferably with a carriage return as delineator to help make it readable). 

Here is a mock-up where the left two columns would be the source data and the right two would be an example of the output:

Client ID	Product				Client ID	Products
1	A				1	A B C G
1	B				2	A
1	C				3	B D
2	A				4	B C
3	B				5	A
3	D
1	G
4	B
4	C
5	A

Thanks for any help you can give. 

bpatel

HI @daavvt ,

You can use the summarize function to group by client id and concatenate by product

Hope this helps!