Unpivoting Table Data

The Unpivot node is used to convert data from columns to rows. You can select one or more columns to be unpivoted.

To unpivot the table data:

  1. Connect the source node to the Unpivot node.
  2. Double-click the Unpivot node. The properties page is displayed.
  3. Click the Properties tab and click Edit Properties.
  4. Enter the following details and click Save.
FieldDescription
Unpivot Columns

List of columns to be unpivoted. The columns selected will be removed from data and two new columns will be added to the dataset.

NOTE All the unpivot columns must have the same datatype.

Unpivot KeyThe names of the selected unpivot columns.
Unpivot ValueThe corresponding values of the selected unpivot columns.
  1. Click the Preview Data tab to view the updated data.

NOTE For details on derivations, see Derivations.

NOTE As the Snowflake environment does not support column aliasing for unpivot queries, the unpivot columns will result in incorrect data, and the pipeline build will fail. To resolve this issue, set the advance configuration dt_use_iwx_column_aliasing = false to disable the column aliasing and continue with the pipeline build.

Type to search, ESC to discard
Type to search, ESC to discard
Type to search, ESC to discard
  Last updated on Jan 6, 2023
Next to read:
Performing Advanced Analytics

For more details, refer to our Knowledge Base and Best Practices!

For help, contact our support team!

© UNIPHORE TECHNOLOGIES 2025 | Confidential

On This Page
Unpivoting Table Data