Row Denormaliser
Description
Row denormaliser is a step in the Transformation Plugin for Process Studio Workflows. The Row De-normalizer step de-normalizes data by looking up key-value pairs in the normalized data and assigning them to new fields in the output rows ad de-normalized data. It also allows you to immediately convert data types. This method may use aggregates and needs the input rows to be sorted on the grouping fields.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
| 2 | Key field | The field that defined the key of the output row. |
| 3 | Group fields | Specify the fields that make up the grouping here. |
| 4 | Target fields | Select the fields to de-normalize by specifying the String value for the key field (see above). Options are provided to convert data types. Strings are most common as key-value pairs so you must often convert to Integer, Number or Date. If you get key-value pair collisions (key is not unique for the group specified) specify the aggregation method to use. |