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.