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

Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.
SOLVED

Populate one single column with data from several columns

julianveda
7 - Meteor

Hi Community,

 

I wonder if you could help me with knowing how I could put in a single column several information that is distributed across several columns.

See the image below to understand the example of the existing information (before) and the expected result (after).

 

Thanks for your time

Julian

4 REPLIES 4
Yoshiro_Fujimori
15 - Aurora

@julianveda ,

 

Here is one way of doing this.

Workflow

Yoshiro_Fujimori_0-1684590989826.png

After Transpose tool, update all the column names to "Title 2", so that Cross Tab tool can put all the value together.

Output

Yoshiro_Fujimori_1-1684591123653.png

 

The order changes from the original data.

If you want to keep it, you may want to add record id first and sort with the record id at the end.

(Or sort with column 2, if that is the correct order.)

julianveda
7 - Meteor

Thank you! exactly what I needed :) 

julianveda
7 - Meteor

Hello again community,

 

I realized that actually my case was a little bit more complex than initially stated. What I actually have is :

 

julianveda_0-1684768305463.png

 

As you can see I have the same term repeated in several columns and I would like to create a single column as shown in the image. When doing the solution proposed by  Yoshiro, that worked very well in my first case, I obtained a single column but with repeated values and I would like to create a list with unique values as in the figure above. would you have any ideas I might test to do this ?

 

Thanks for reading,

julian

Dina
9 - Comet

The "Unique" tool should be able to do the trick.

Dina_1-1687205097202.png

Dina_2-1687205128635.png