community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Merge multiple Columns into 1 Coulmn

Meteoroid

Hello,

 

I am trying to merge multiple coulmns into one coulmn.  The data looks like this.

Source Data.PNG

 

I would like it to end up like this.

New Coulmns.PNG

 

 

Highlighted
Alteryx Alumni (Retired)

Use a Transpose tool and check the non-merge columns as key fields. This will get the values into a single column.

Then just use a Join tool to connect back with the key fields as the basis for your join.

Meteoroid

Yes, that worked thank you.

Labels