Transformation steps for the Hierarchical Data stage (DataStage®)

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

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

Parent topic: Hierarchical data transformation (DataStage)