Table of Contents


  1. Preface
  2. Introduction to Data Transformation
  3. Data Processor Transformation
  4. Wizard Input and Output Formats
  5. Relational Input and Output
  6. Using the IntelliScript Editor
  7. XMap
  8. Libraries
  9. Schema Object
  10. Command Line Interface
  11. Scripts
  12. Parsers
  13. Script Ports
  14. Document Processors
  15. Formats
  16. Data Holders
  17. Anchors
  18. Transformers
  19. Actions
  20. Serializers
  21. Mappers
  22. Locators, Keys, and Indexing
  23. Streamers
  24. Validators, Notifications, and Failure Handling
  25. Validation Rules
  26. Custom Script Components

Relational Output Port Configuration

Relational Output Port Configuration

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
to be
Output Mapping
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
Choose Hierarchy
. The Developer tool displays only the nodes from the root level and below the root level in the
Transformation input
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
Transformation input
area to the
Transformation output
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
Transformation output
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
Transformation output
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
Transformation output
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
Transformation output
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
Show Lines
. Select to view all the connection lines or just the lines for selected ports.

Updated February 12, 2020