HJoin step

Transform the items from two lists into one nested list.

This join is called a hierarchical join because the step creates a hierarchical structure. Therefore, the HJoin step joins the data and creates the hierarchy.

Parent List
Specify the parent list. The parent list cannot already have a containment relationship with the child List.
Child List
Specify the child list.
Optimization Type
If all of the records have the same key and are consecutive to each other, select In-memory as the optimization type.
Parent Keys
Specify the key to use to join the lists.
Child Keys
Specify the key to use to join the lists.