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 rows into one row by value of a column

eyalgrn
6 - Meteoroid

Hello,

 

I am trying to concatenate several rows into one row, so several cells in same column but different rows should go into one cell. The grouping should be done by the value of another column.

 

Here is the data. So all the values in cells C2, C3 and C4 (same item - "XZR") should be concatenated into one cell - C20. The same is for each of the items ("XZR", "AWE" and "TUP"). Please note that I need to show them in a separate lines within the new cell (so I also need to concatenate them with a line break, as shown in the example). 

 

Untitled.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I appreciate your help!

 

Thanks,

 

Eyal

6 REPLIES 6
jrgo
14 - Magnetar

@eyalgrn,

 

You can use a Summarize tool to concat values from rows

image.pngimage.png

eyalgrn
6 - Meteoroid
Perfectly works!! Thanks!
Present_guy
8 - Asteroid
thank you -- just what I needed
subhajits11
8 - Asteroid

thank you

akumar14
5 - Atom

Hi,

In the above example if in item details, same value is appearing multiple times and I want to concatenate only distinct values, how can we do that?

 

Thanx

subhajits11
8 - Asteroid

Can you try "Unique" tool to achieve that for the [Column name]. 

Labels