Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Help with transposing and rearranging data

mkatkhuda
5 - Atom

Hi everyone, 

 

I'm having real trouble converting my data into a specific format.  My data includes products, with demand/cost/supply figures across multiple years. I tried to use the transpose function but had very little success. I included a data set with a similar structure below.  Any and all advice is welcome and much appreciated! 

 

 

Capture.PNG

Thank you!

 

2 REPLIES 2
JoshKushner
12 - Quasar

You can do this by transposing the data set, separating the year from the header, then holding back the year when cross tabbing back with '+' as the separator.

The Multi-Field tool is set to add parentheses around all fields (including unknown) except for the Product and Year.

 

In my sample workflow I've only included 2018 & 2019, but it can scale for any number of headers and years.

 

Workflow

workflow.PNG

 

Results

results.PNG

 

Cross Tab

cross tab.PNG

mkatkhuda
5 - Atom

Worked like a charm! Thanks!

Labels