Table of Contents

Search

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

Components

Components

Working with relational output

Working with relational output

You can use the
Relational Output
tab to select how to display the model data, select the data normalization mode of the model, and perform actions on output groups in the model.
Display options
You can select one of the following display options in the
Display by
field of the
Relational Output
tab:
  • Display output groups. View the way data is grouped together in the output.
  • Display incoming records. Understand how Intelligent Structure Discovery receives input records.
The display option you select doesn't affect the structure of the data at run time.
Data normalization mode
When a model that is based on a JSON, XML, or XSD file contains nested repeating groups,
Intelligent Structure Discovery
normalizes the input data and assigns each nested repeating group to its output group. For models that are based on other input types,
Intelligent Structure Discovery
doesn't automatically normalize the data. You can change the normalization mode of the model in the
Data Normalization
field of the
Relational Output
tab. The normalization mode affects the structure of the data at run time.
Perform actions on output groups
You can perform the following actions on output groups on the
Relational Output
tab:
  • Rename a node. To rename a node, right-click the column that represents the node, and type a name, for example,
    City
    .
  • Exclude a node. To exclude a node from an output group, right-click the column and select
    Exclude from Structure
    . If you exclude the node, the data is not parsed in run time.
The actions that you perform affect the structure of the data at run time.
The
Relational Output
tab can display up to 200 rows of data. If you have a large amount of data or many repeating groups, the
Relational Output
tab might not display all the output groups.

0 COMMENTS

We’d like to hear from you!