Swing Down

About Swing Down

Swing Down transposes the headers of selected columns into rows in a new column and collects their values into another new column. These columns are appended to the right of the dataset and the original columns are removed. For every row in the input data, each Swing Down Column will create a new row in the output.

Example

Swing Down is useful for dealing with tables where data categories have been split out into separate columns. The categories and values need to be ‘flattened’ into a pair of columns to enable reporting, querying or processing downstream.

Using Swing Down

1. Select ‘Swing Down’ in the operations menu.
2. Select one or more Swing Down Columns. The headers for these columns will be transposed as rows in the Header Column.
3. Name the Header Column.
4. Name the Value Column. This column collects all the values from the Swing Down Columns.