Alteryx Designer Desktop Discussions

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

Transpose of Data

prveenk86kumar
7 - Meteor

Hi All, I am trying to transpose attached input file_1 to columns but everything is getting displayed in one column. I need the data in below summary format and only selected columns.

 

Capture.JPG

3 REPLIES 3
FrederikE
13 - Pulsar

For this kind of Problem you often need a Summarize and Text to Column Tool as well. 

Check the attached solution. 

 

Also you might want to check out the "Total Transpose" Macro - I like to use this for such problems. 

Total Transpose Macro 

suby
11 - Bolide

Find the attached the workflow..

 

Hope this helps..

binuacs
21 - Polaris

@prveenk86kumar one way of dong this

 

binuacs_0-1654463256846.png

 

Labels
Top Solution Authors