Transformation steps for the Hierarchical Data stage

Transformation steps for the Hierarchical Data stage are available from the palette in the Assembly Editor.

Aggregate step
Perform hierarchical aggregations on the items in a list.
H-Pivot step
Use the H-Pivot step to transform multiple columns into a single hierarchical column under a list.
HJoin step
Transform the items from two lists into one nested list.
Order Join step
Join items based on their position in two lists.
Regroup step
Use the Regroup step to create a parent-child list relationship from a single list.
Sort step
Sort the items in a list by one or more keys.
Union step
Use the Union step to combine two lists that have different structures into a single list that has a predefined structure.
V-Pivot step
Use the V-Pivot step to transform records into fields of another record.

Parent topic: Hierarchical data transformation