Alteryx Designer Desktop Discussions

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

Complex cross tab to arrange data

503Phil
5 - Atom

Hello Community!

 

I hope everyone is having a good week.  I'm fairly new to Alteryx and trying to figure out the best way to do what appears to be a complex data arrangement (Hoping this is just me!).  This is needed to meet a specific script template and isn't flexible.  I've played around for a few hours and I'm stuck.

 

Here's a screenshot of what I'm trying to accomplish:

 

503Phil_0-1594936407448.png

 

Data, Country and Product being my primary fields but cannot for the life of me figure out how to get all of the sizes and quantities collapsed to one row.

 

Any pointers or advice would be appreciated!

 

Thank you!

2 REPLIES 2
DavidP
17 - Castor
17 - Castor

If you use a Tile tool you can split the data and crosstab Size and Quantity separately, then join them together again. Only problem is that you have to manually arrange the size and quantity columns in the join tool to get them in the right order.

 

DavidP_0-1594939459902.png

 

503Phil
5 - Atom

Thank you David!  This worked out great and produced the exact results I was looking for.

Labels
Top Solution Authors