Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!
SOLVED

Combine 2 columns and group values into one column

Highlighted
5 - Atom

Hello!

 

Beginner user, not sure if this question has already been answered. I am looking to combine 2 columns to get a single column, but with single grouped value of column 1 repeated only once.

 

For example:

 

Input:

ashishshetty_0-1602878352984.png

Output:

ashishshetty_1-1602878376219.png

Attached is a sample excel input.

 

Appreciate the help! Thank you!

Highlighted
16 - Nebula
16 - Nebula

I'd suggest:

jdunkerley79_0-1602879153622.png

Start by using a summarise tool to concatenate all the values in Column2 to a single string for each Column1 separated by columns

Then you can use a formula tool to add Column1 value in front of the concatenated values

Finally a text to columns tool will break it up into the rows you need.

 

Sample attached

 

Highlighted
5 - Atom

Thank you very much!

Labels