Alteryx Designer Desktop Discussions

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

Transform Tools - Rows to columns

AmAm
7 - Meteor

Hi,

 

I am trying to shift the rows into columns. I know that I should use transformation tool, I tried few but it did not work. So I want some help plz. 

 

Thank you in advance,

 

I have this 

AmAm_0-1651082483649.png

and I want this 

AmAm_2-1651082551258.png

 

3 REPLIES 3
IraWatt
17 - Castor
17 - Castor

Hey @AmAm,

You need to have name as a key column and the rest as data columns. Like so (I've attached an example workflow):

IraWatt_0-1651082860022.png

The key columns will remain the same and the data columns will pivot round them. 

 

AmAm
7 - Meteor

@IraWatt Thanks man!!

IraWatt
17 - Castor
17 - Castor

No worries at all ! :) 

Labels