Alteryx Designer Desktop Discussions

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

HELP

imrahu01
8 - Asteroid

I am trying to learn how to use cross tab and transpose tool. is there anyone here can help me with the attached file. I am trying to show column header from V to BX(state name)  vertically. Can I do it using cross tab and transpose tool?

2 REPLIES 2
DavidP
17 - Castor
17 - Castor

The best way to learn how to use CrossTab and Transpose is to open the examples when you click on the tools in the transform tool palette and work through.

 

Then also play around with them using your own data.

 

In this case, the Transpose tool will do what you want. Select everything except for the state fields as key columns.

 

DavidP_0-1595370112576.png

 

imrahu01
8 - Asteroid

Thank you so much for your help. @DavidP 

Labels