12.3.12 Flattened Table to Hierarchy

This section provides information about the Flattened Table to Hierarchy component.

1. Drag and drop the PC Hierarchy component on the canvas.
2. To position the component on the canvas, drag and move the component, or click the component and use arrow keys on the keyboard to move it around.
3. Connect an EDD to the input of the Flattened Table to Hierarchy component. and to the Mapping component.
4. Connect the output of the Flattened table to Hierarchy component to the Mapping component.
5. At any given time, right-click the component and select the relevant options to either delink, remove inlinks or outlinks, or delete the component.
6. To define the expression, double-click the Flattened table to Hierarchy component to view the Flattened Table to Hierarchy window.
7. Choose the Hierarchy Type as Balanced, Ragged, or Skipped. Click ? to view the details and understand how the hierarchies are defined.
8. Specify the Number of levels in the hierarchy.
9. Specify the Parent Node Column Name and Child Node Column Name which are used in the mapping.
10. Select the Key Elements from the drop-down list.
11. Select all the node level details from the respective drop-down lists.
12. Click Review to view the transformation changes.
13. Click Ok.