Alteryx Designer Desktop Discussions

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

Transpose from rows to columns

dottman
7 - Meteor

Hello - wondering if someone could help me go from the first image to something similar to the second image. There's probably an obvious solution, but I can't figure it out. Appreciate any help.

 

 

ofc number to columns.PNG

 

ofc number to columns.PNG

4 REPLIES 4
ed_hayter
12 - Quasar

You want a cross tab tool here i believe with OFC as your "Column Headers" and Accounted AMT as your "Column Data" - then select an aggregation method if you group by a particular column. In this case without a group by your aggregation method does not matter as much.

Pilsner
10 - Fireball

One way you can approach it is this:

Screenshot 2023-07-24 153930.png

 With the cross-tab tools configured as follows:

Screenshot 2023-07-24 154051.png

You can rearrange the order of the rows within the union tool if needed

cjaneczko
12 - Quasar

Find attached workflow and screencaps.

 

image.pngimage.pngimage.png

dottman
7 - Meteor

Excellent, thank you both!

Labels