Alteryx Designer Desktop Discussions

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

How to transpose columns to rows and put headers in the row too

Carl_in_CT
7 - Meteor

OK, one more today, hoping to finish this data output today.

 

I have to transpose this:

 

Transaction TypeBenefit Monthcode 5601code 5602code 5603code 5604
TRN12/18/2018175.548  
PRK-CR12/18/2018  500


Into this:

 

Transaction TypeBenefit Month  
TRN12/18/2018code 5601175.5
TRN12/18/2018code 560248
TRN12/18/2018code 5603 
TRN12/18/2018code 5604 
PRK-CR12/18/2018code 5601 
PRK-CR12/18/2018code 5602 
PRK-CR12/18/2018code 560350
PRK-CR12/18/2018code 56040

 

I can transpose the data fine but I can't figure how to get the "code" field headers to be included in the new rows.

11 REPLIES 11
Carl_in_CT
7 - Meteor

OK, it works!  It wasn't the transpose function that was the trouble.  It was one of the downstream select functions that went wonky and I just didn't see it.  Sorry to bother folks, normally I would be more careful in checking everything before asking for help but I was running out of time and a little desperate.  Anyway, thanks for all of the replies!  Hopefully one day I will be good enough at this to help someone else.

Carl_in_CT
7 - Meteor

Here is the final workflow.

 

Capture2.PNG

Labels