Concept: Unpivot Stages
The Unpivot stage enables you to arrange the data in derived datasets in a way
that is more meaningful to you. You can convert fields (columns) to rows. The unpivot
process consolidates data from 2 or more similar fields into a pair of new fields:
- A field created from the original field names (referred to as Input Fields)
- A field created from the original field values (referred to as Output Values)
When you unpivot:
- Workday populates the new fields with the values you specified for the unpivot.
- Workday repeats row values in the input fields you didn’t include in the unpivot.
You can:
- Apply the unpivot to all field types.
- Rename your output values.
- Specify names for your pairs of new fields.
- Unpivot up to 150 input fields within each Unpivot stage.
- Create multiple pairs of new fields within each Unpivot stage.
- Add or delete an Unpivot stage anywhere in pipelines of a derived dataset.
Workday recommends that you create multiple pairs of new fields in a single Unpivot stage
rather than 1 pair of new fields in many Unpivot stages.