Transpose Tool
Use Transpose to pivot the orientation of a data table.
It transforms the data so you can view horizontal data on a vertical axis. This tool is useful for extracting non-conforming data. There is no limit to the number of rows or columns that can be transposed.
Tip
This tool has a One Tool Example. Visit Access Sample Workflows to learn how to access this and many other examples directly in Designer Cloud.
Configure the Tool
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 calledValue
.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.
Check the Columns to Group By (Optional).
Select the action you want to take If Columns Are Missing From Input:
Warn (Continue Data Processing): Throw a warning in the Results Grid, but continue processing rows.
Error (Stop Data Processing): Throw an error in the Results Grid 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.