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

Transpose Columns to Rows

fiorano
8 - Asteroid

Hi,

 

I have the following sample data :

 

 Unit Type1Type2Type3
 SouthWest                      -             3,542
 MidWest                 3            12,360         97,737
 Northern 1                 5              7,775 
 South East 5                 2                    -         242,352

 

 

is it possible to transpose it to the following:

 

 Unit TypeTotal
 SouthWest Type3              3,542
 MidWest Type13
 MidWest Type2            12,360
 MidWest Type3            97,737
 Northern1 Type1                     5
 Northern1 Type27,775
 South East 5 Type12
 South East 5 Type3          242,352

 

This is just an example as there maybe upto 60 'Types' that are in individual columns.

 

Many thanks,

3 REPLIES 3
PhilipMannering
16 - Nebula
16 - Nebula

Hey Fiorano,

 

You can use the transpose tool,

 

Transpose - Capture.PNG

JShankman
7 - Meteor

Transpose tool followed by a select tool to rename the columns. Then you would want to filter on the Total column to get rid of the empty or "-" fields. Make sure the "Dynamic or Unknown Fields" box is checked in the Transpose tools data fields to ensure additional "Type" columns get picked up.

PhilipMannering
16 - Nebula
16 - Nebula

Hey Fiorano,

 

You can use the transpose tool,

 

Transpose toolTranspose tool

Labels