Infoworks 5.3.1
Prepare Data
Documentation for Versions 2.x, 3.1.
Introduction
Creating a Pipeline
Designing a Pipeline
Building A Pipeline
Pipeline Settings
Functions Library

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.

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