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.

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:

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.