Transpose tool icon

Transpose Tool

Last modified: September 09, 2021

Docs are available before the release of Designer Cloud so you can get a sneak peek. This content might change between now and the official release.

One Tool Example

Transpose has a One Tool Example. Visit Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer Cloud.

Use Transpose to pivot the orientation of a data table. It transforms the data so you can view horizontal data on a vertical axis. The Transpose tool is the reverse application of the Cross Tab tool, which pivots the orientation of the data from vertical to horizontal.

This tool is useful for extracting non-conforming data. There is no limit to the number of rows or columns that can be transposed.

Configure the Tool

  1. Check the Columns to Transpose to pivot the table around. Checked columns are pivoted vertically. The column header populates a new column called Name and the values populate a new column called Value.
    • Use Check All to check all of the columns.
    • Running a workflow can introduce new columns that were unknown at the time of configuration. Check Dynamic or Unknown Columns to include dynamic or new columns.
  2. Check the Columns to Group By (Optional).
  3. Select the action you want to take If Columns Are Missing From Input:
    • Warn (Continue Data Processing): Throw a warning in the Results window, but continue processing rows.
    • Error (Stop Data Processing): Throw an error in the Results window and stop processing rows.
    • Ignore (Continue Data Processing): Ignore missing columns and continue processing rows.

Columns to Transpose Example

The Columns to Transpose that you check replicate vertically and create a row for each column you select to transpose.

For example, you have a table containing 2 rows and 4 columns. When you transpose the table and select the Columns to Transpose without deselecting any columns, you end up with 8 rows and 2 columns, including the Name and the Value of the selected columns.

If you deselect any Columns to Transpose, the number of rows output from the Transpose tool decreases.

The number of rows you end up with after transposing the table is equal to the number of initial rows multiplied by the number of columns selected.

 

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.