Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

Transpose Help

anniegullo
6 - Meteoroid

I know this has to be easier than I'm making it, but some of the other examples are confusing me. Can someone help to (hopefully attach a working example) transpose/crosstab this data? I'm looking for the "after". Thank you!!

 

 

anniegullo_0-1596745833426.png

 

2 REPLIES 2
DavidP
17 - Castor
17 - Castor

Hi @anniegullo 

 

Here you go. The Tile tool and Dynamic rename is used to restore the new column names after the CrossTab tool changed all the non alphanumeric characters to underscores.

 

DavidP_1-1596746913959.png

 

Sntrada
11 - Bolide

@anniegullo 

 

Hello!

 

See attached. I actually have the dates as headers, not sure if this goes with what you wanted. 

 

Let me know if you have any questions. 

 

 

Labels