Configuring data output

Double-click tFileOutputXML to show its Basic settings view.

Enter the XML output file path.

Define the row tag that will wrap each row of data, in this use case ContractRef.

Click the three-dot button next to Edit schema to view the data structure, and click Sync columns to retrieve the data structure from the input component if needed.

Switch to the Advanced settings tab view to define other settings for the XML output.

Click the plus button to add a line in the Root tags table, and enter a root tag (or more) to wrap the XML output structure, in this case ContractsList.

Define parameters in the Output format table if needed. For example, select the As attribute check box for a column if you want to use its name and value as an attribute for the parent XML element, clear the Use schema column name check box for a column to reuse the column label from the input schema as the tag label. In this use case, we keep all the default output format settings as they are.

To group output rows according to the contract number, select the Use dynamic grouping check box, add a line in the Group by table, select Contract from the Column list field, and enter an attribute for it in the Attribute label field.

Leave all the other parameters as they are.

Configuring data output

Positional

Procedure