To transform hierarchical input to relational output, select a schema to define the hierarchical data. You must also define the relational output ports. On the Ports panel, define groups of ports and map the nodes from the hierarchical schema to the ports.
To define an output mapping, select the
Data processor mode
Output Mapping and Service
The mapping uses a schema to define the hierarchical input. If the schema has more than one element that can be a root element, choose a node to be the root element. To define a node as a root, click
. The Developer tool displays only the nodes from the root level and below the root level in the
Show As Hierarchy
to display the output ports in a hierarchy. Each child group appears underneath the parent group.
Create ports with one of the following methods:
Drag nodes to ports
Drag nodes from the
area to the
area. If you drag a node to a group, the Developer tool adds a port to the group. Otherwise, it creates a group with the port in it.
Manually create the ports
To create a port, select an empty field in the
area and click
. If you do not select a field inside a group, the Developer tool creates a group and adds the port to the group.
When you drag nodes to the
area, the Developer tool updates the location field with the location of the node in the hierarchy. If you manually create ports, you must map a node to the port. Click the
column and select a node from the list.
When you drag a multiple-occurring node into a group that contains the parent element, you can configure the number of child element occurrences to include. Or, you can replace the parent group with the multiple-occurring child group in the transformation output.
To create a group, drag a node to an empty column in the
area. If you drag a multiple-occurring child node to an empty input or output column, the Developer tool asks you to relate the group to other output groups. When you select a group, the Developer tool creates keys to relate the groups.
You can also create a new group by clicking
. Enter a name for the group.
Configure related groups of output ports in the
area. When the Developer tool prompts you to relate output groups, it adds the keys to the groups. You can also manually add ports to represent keys.
To view lines that connect the ports with the hierarchical nodes, click
. Select to view all the connection lines or just the lines for selected ports.