Table of Contents

Search

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

Data Transformation User Guide

Data Transformation User Guide

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
or
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
area.
Click
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
New
Field
. 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
Location
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
New
Group
. 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 September 26, 2018