When you configure a Structure Parser transformation, you associate an intelligent structure model with the transformation and select the output type.
To associate an intelligent structure model with the transformation, you can select an existing model or create a new model. If you create a new model, you can select one of the following actions:
•Design new. You create the model in the Intelligent Structure Model page. For more information about creating an intelligent structure model, see Components.
•Auto-generate from a sample. You select a sample file and Intelligent Structure Discovery creates the model and saves it in the location that you select.
You can also select and view a model on the Intelligent Structure Model page before you use it.
When you configure a Structure Parser transformation, you select the data output type. The transformation can generate the following output types:
•Relational
•JSON
•JSON lines
•XML
•Avro
•Parquet
•ORC
Configuring a Structure Parser transformation
Add a Structure Parser transformation to a mapping and configure transformation settings.
1Add a Structure Parser transformation to the mapping and configure general settings.
2On the Properties panel, click Structure Parser and choose one of the following options to associate an intelligent structure model with the transformation:
Option
Description
Select
Select an existing intelligent structure model.
New > Design New
Create a new model in the Intelligent Structure Model page.
New > Auto-generate from sample file
Select a sample file and a location for the model and click Create. Intelligent Structure Discovery creates the model and saves it in the selected location.
3Select the output type for the Structure Parser transformation from the Output As list.
4If you select the JSON output type, you can select Include empty tags to add all the model tags to the output at run time, including tags that don't exist in the input. The transformation adds tags that don't exist in the input as empty tags with a NULL value.
5On the Properties panel, click Incoming Fields and configure the incoming fields.
6On the Properties panel, click Field Mappings and configure field mapping.
7Optionally, on the Properties panel, click Advanced and configure the transformation scope.
8Link the previous transformation on the map to the Structure Parser transformation
9Link the Structure Parser transformation to the downstream transformation and select an output group.
Selecting an intelligent structure model
Select an intelligent structure model to include in the Structure Parser transformation on the Structure Parser tab of the Properties panel.
1In the Properties panel of the Structure Parser transformation, click the Structure Parser tab.
2Click Select.
The Select Intelligent Structure dialog box appears.
3In the Explore list, select an intelligent structure model.
4To search for an intelligent structure model, select the search criteria, enter the characters to search for in the Find field.
You can search for an intelligent structure model by name or description. You can sort the intelligent structure models by name, type, description, tags, status, or date last modified.
5Choose the intelligent structure model to include in the Structure Parser transformation and click Select.
The intelligent structure model appears in the Properties panel.
Selecting an output group
When you link the Structure Parser transformation to a downstream transformation, you must select one output group to map to the downstream transformation. If you want to map more than one output group, create a different downstream transformation for each output group.
1Link the Structure Parser transformation to a downstream transformation.
The Select Output Group dialog box appears.
2To map the data that was identified by the intelligent structure, select one of the output groups. Alternatively, to map the data that was not identified by the intelligent structure, select the Unidentified output group.