12.3.12 Flattened Table to Hierarchy
This section provides information about the Flattened Table to Hierarchy
component.
- Drag and drop the PC Hierarchy component on the canvas.
- 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.
- Connect an EDD to the input of the Flattened Table to Hierarchy component. and to the Mapping component.
- Connect the output of the Flattened table to Hierarchy component to the Mapping component.
- At any given time, right-click the component and select the relevant options to either delink, remove inlinks or outlinks, or delete the component.
- To define the expression, double-click the Flattened table to Hierarchy component to view the Flattened Table to Hierarchy window.
- Choose the Hierarchy Type as Balanced, Ragged, or Skipped. Click ? to view the details and understand how the hierarchies are defined.
- Specify the Number of levels in the hierarchy.
- Specify the Parent Node Column Name and Child Node Column Name which are used in the mapping.
- Select the Key Elements from the drop-down list.
- Select all the node level details from the respective drop-down lists.
- Click Review to view the transformation changes.
- Click Ok.