Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

Alteryx Designer Desktop Discussions

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

Alteryx Desktop Cross Tab

RKahle
7 - Meteor

Hello, I am trying to cross tab the attached so there is (1) record with a new column for each destination. For this example, there will be (1) record with (4) columns. RecordID, Destination 1, Destination 2, and Destination 3.

 

 

 

2 REPLIES 2
Prometheus
12 - Quasar

@RKahle You can use the Transpose tool to do that. I added another couple of records with another RecordID to show how the Tile tool can group these and count how many exist for each RecordID. Is this what you're looking for?

 

Trans.PNG

Smart Tile.PNG

Results.PNG

binuacs
21 - Polaris

@RKahle One way of doing this

image.png

Labels