Table of Contents

Search

  1. Preface
  2. Components
  3. Business services
  4. File listeners
  5. Fixed-width file formats
  6. Hierarchical schemas
  7. Intelligent structure models
  8. Mapplets
  9. Saved queries
  10. Shared sequences
  11. User-defined functions

Components

Components

Navigating the output

Navigating the output

The following image shows part of the
Intelligent Structure Details
page, with the input data panel above, and below, the intelligent structure in the Visual Model tab, and the output groups in the
Relational Output
tab:
The image shows part of the Intelligent Structure Details page, with the input data panel above, and below, the intelligent structure in the Visual Model tab, and the output groups in the Relational Output tab.
The following table describes the areas of the Mapping Designer:
Mapping Designer Areas
Description
1. Input data panel
Shows the data from the sample file.
2. Intelligent structure panel
Shows the intelligent structure and output groups.
3. Visual Model tab
Shows the intelligent structure, and the following icon menu bar:
  • Export icon. Export the model.
  • Zoom In icon. Increases the size of the model.
  • Zoom Out icon. Decreases the size of model.
  • Display icon. Toggle model display orientation between landscape and portrait folder view.
  • Refresh icon. Refresh the model.
4. Relational Output tab
Shows the output groups that the intelligent structure generates.
5. Excel sheet display selection
Select the Excel sheet for which to display data in input data panel . This is displayed only when the sample file is an Excel with multiple sheets.
When you toggle the model display orientation to portrait, the model shows as a folder tree. Each node shows as a level in the tree, and you can select the same node menu options as are available in the model landscape view. The following image shows the model as a folder tree.
The image shows the visual model as a folder tree, with the input data panel above, and the output groups in the Relational Output tab.
A node in the intelligent structure is represented by a column in an output group. The column contains all the iterations of data that relate to the node.
To better understand the output, you can select a node and view the corresponding data in the input data panel and in the related column in the relevant output group. In this image, two nodes are highlighted, and data can be traced from the input data to the output group. Use the
Relational Output
tab to determine the type of output the model produces for each node, for groups of nodes, and for the model as a whole.
Each group has an information icon at the left of its column display. When you hover over the information icon, the entire output group is highlighted and the name of the output group is displayed.
The following image shows a highlighted output group named
customer details
with the name of the output group displayed:
The image shows a highlighted output group named customer details, with its name displayed.
Work with both the Visual Model tab and the
Relational Output
tab for best results. To change the output, you can adjust and refine the intelligent structure. When you refine the intelligent structure in the Visual Model tab, you can immediately see the effect on the output groups in the
Relational Output
tab.
By default, the
Relational Output
tab shows data according to output groups. You can select to display groups according to incoming records, to see how incoming data is grouped in the intelligent structure. The representation of incoming records might be normalized to address the presence of repeating elements.
For models based on an Excel file that contains multiple sheets, all sheets are displayed in the visual model. You can select which sheet to display in the input data panel.


Updated January 22, 2021