community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Transpose Columns to Rows

Highlighted
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,

Alteryx Certified Partner

Hey Fiorano,

 

You can use the transpose tool,

 

Transpose - Capture.PNG

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.

Alteryx Certified Partner

Hey Fiorano,

 

You can use the transpose tool,

 

Transpose - Capture.PNGTranspose tool

Labels