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.
SOLVED

Transpose / crosstab

lmaughan
7 - Meteor

I need help in transposing the attached data --

Current data to Desired data tab.

 

Not sure if crosstab or transpose is the best tool to use for this.  Thoughts and insights are welcome.

 

 

4 REPLIES 4
Luke_C
17 - Castor
17 - Castor

@lmaughan 

 

The answer would be both! First transpose to get gross and reserve as rows, then crosstab by state:

 

Luke_C_0-1616097593797.png

 

Edited to fix column

 

Emil_Kos
17 - Castor
17 - Castor

Hi @lmaughan,


I need to work on my cross tab transpose skills. As it looks that it could be easily done... Looking at your solution @Luke_C 

 

Emil_Kos_0-1616097854166.png

 

lmaughan
7 - Meteor

So helpful!  Thanks for responding so quickly... this is perfect!

lmaughan
7 - Meteor

 

This is another great solution.. I love how you can take different approaches in Alteryx to get the desired result.

 

Thanks much for your help!

Labels
Top Solution Authors