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.
Solved! Go to Solution.
@ABCDA - please see attached workflow. You'll use summarize tool. Hope this helps!
Perfect- thanks!