Equivalent to power query function Table.Column in Alteryx

[ABCDA]

Thanks in advance for your help.

Looking to create the equivalent to the table column power query function in Alteryx.

The input that I have is the following:

Account	Code
111111111	ABC
111111111	DEF
111111111	GHI
222222222	111
222222222	222
222222222	333
999999999	XXX
999999999	YYY
999999999	ZZZ

Output:

1 line per account with the codes separated by a ","

Account	Code
111111111	ABC,DEF,GHI
222222222	111,'222',333
999999999	XXX,YYY,ZZZ

Any help would be greatly appreciated.

[alexnajm]

This looks like a Summarize tool with a concatenate function!

[usmanbashir · Accepted solution]

@ABCDA - please see attached workflow. You'll use summarize tool. Hope this helps!

[Krzysiek]

Hey

You can use Summarize Tool for instance.

The same would do Cross Tab Tool for you.

Workflow

Configuration of Summarize Tool

[ABCDA]

Perfect- thanks!