Alteryx Designer Desktop Discussions

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

Row to Column

Tommy23
7 - Meteor

Hello,

 

I would like to transpose this rows into column. I have try to use the transpos tool without success. Here you can find an example o what I want to have

 

Input:

Name_Column_1       Name Column_2        Name_Colunm3

          

       Pierre gally

       Juliette Harry

       GeorgeExam

 

Output:

Name_Column_1       Name Column_2        Name_Colunm3

         Pierre gally             Juliette Harry            GeorgeExam

 

Thanks in advance for all your answer,

 

Best regards,

2 REPLIES 2
JagdeeshN
12 - Quasar
12 - Quasar

@Tommy23 

 

Please find attached a sample workflow. With regards to the name of the columns you can handle that in the select after the crosstab.

 

Let me know if this helps.

 

Best,

Jagdeesh Narayanan

AngelosPachis
16 - Nebula

Hi @Tommy23 ,

 

I think you have to form new column headers for the transpose tool to work, because only one of your columns originally contains data.

 

AngelosPachis_0-1611854886041.png

 

Labels