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 Table tab:
Navigate structure output
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. Table 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.
Model portrait folder tree
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 Table 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
CompanyDetails
with the name of the output group displayed:
When you select an output group icon, the name of the output group is displayed.
Work with both the Visual Model tab and the Table 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 Table tab.
By default, the Table 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 August 03, 2020