Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to transpose field/value pair stored in records into columns?

smartleo
5 - Atom

Hello everyone,

 

I am new to Alteryx.  This question might have been asked before as it's quite common I think.  I apologize in advance.  What I am trying to do is to transpose the following input into something like output.  I don't might some manual step as long as the workflow is simple to use.  Please see Testing dataset file attached for your reference.  Any tips would be much appreciated.

 

input file

 input file.JPG

 

 

 

Output file

smartleo_0-1663379928366.png

 

 

Best regards,

Leo

3 REPLIES 3
Luke_C
17 - Castor

Hi @smartleo 

 

You would want to use crosstab instead of transpose:

Luke_C_0-1663381026032.png

 

smartleo
5 - Atom

Thank you so much for your help! Really appreciated it!

Luke_C
17 - Castor

Happy to help! Glad you're all set. 

Labels