In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How to transpose/crosstable to get the output

Santhoshraj
6 - Meteoroid

Hi, i have a table like this with millions of rows:

 

Program idmanagermonths +/-scalecode
NJNJohn2443p2efr
AJNJim3233p4tew
TRPDwight0345t0tre

 

I need to change the orientation of the table like this:

 

Program idNJNAJNTRP
managerJohnJimDwight
months +/-230
scale443233345
codep2efrp4tewt0tre

 

Can someone help me with this?

2 REPLIES 2
suwenchuan
7 - Meteor

Hi, proposed solution attached

binuacs
21 - Polaris

@Santhoshraj One way of doing this

image.png

Labels
Top Solution Authors