Reference: Unpivot Stages
For Workday to convert fields (columns) to rows in derived datasets, follow
these requirements:
Requirement | Description |
|---|---|
Number of Input Fields | Select at least 2 input fields to unpivot. Enter the same number of input fields for every group of input fields that you
unpivot in a single Unpivot stage. Example: If you select 5 input fields to unpivot, each subsequent group of input fields
that you unpivot in the stage must contain 5 input fields. If you unpivot multiple groups of input fields, the total number of input fields
you can use for all groups together in a single Unpivot stage is 150. |
Input Field Types | Select input fields that are the same field type, such as Text or Numeric. You can unpivot
all field types. If you select input fields consisting of Instance or
Multi-Instance fields, these input fields must use the same business
object. If you select input fields consisting of Numeric fields, these input
fields must have the same number of digits specified before and after
the decimal point. |
Output Field Names | Enter unique names for all pairs of new fields created from unpivoting. |