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

Repeating groups

Repeating groups

Intelligent Structure Discovery
creates a repeating group for input data such as a table or array, where a row or set of fields repeats as a group.
For example, you create a model for the following JSON input:
{ "CompanyID": 210850, "Name": "Tollers Shipping", "Address": "701 Natash Ave.", "City": "San Diego", "Department": [ { "Domain": "Logistics", "Identifier": "21973b77", "Employees": [ { "name": "Sujitha Naarana", "employeeID": "2100Z9" } ], }, { "Domain": "Accounting", "Identifier": "301ad177", "Employees": [ { "name": "LeTroy Prince", "employeeID": "31910a" } ] } ] }
The following image shows the model you created with the JSON input:
The intelligent structure contains two output groups. The second output group is a repeating group that contains a repeating group.
The model contains an
Employees
repeating node that contains an
Employee
group node. The
Employee
group node has a
name
child node and an
employeeID
child node.
If you examine the image, in the Visual tab, the
employeeID
child node in the
Employees
repeating group is highlighted. In the Table tab, the
DepartmentItem
output group contains the
employeeID
node. The columns that relate to the
employeeID
node are highlighted.
A repeating group is displayed in the Visual Model with three overlapping circles for the parent node.
The following image shows the
Employees
repeating group:
The Employees repeating group node contains an employee node. The employee node contains a name child node and an employeeID child node.


Updated August 03, 2020