Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

concatenate multiple rows into one with Comma separation

AJ-CH
8 - Asteroid

Hello, 

I am trying to find a solution to merge multiple rows into one row.

 

Input
CNItem
AABC123
AABC456
BABC789
BABC789
CABC012
DABC001

 

Desired Output
CNItem
AABC123, ABC456
BABC789, ABC789
CABC012
DABC001

 

any help will greatly be appreciated.

3 REPLIES 3
Thableaus
17 - Castor
17 - Castor

Hi @AJ-CH 

 

Use the Summarize tool, grouping by CN field and using String concatenation on the Item field.

 

Cheers,

Thableaus
17 - Castor
17 - Castor

@AJ-CH 

 

Example attached.

 

summarizeexample.PNG

 

Cheers,

AJ-CH
8 - Asteroid

@Thableaus, thanks for quick solution.. it worked.. 🙂

Labels