Creating a Job to split and flatten an XML file

Procedure

In the Integration perspective, right-click the Job Designs node and click Create Standard Job.
Enter a name, purpose and description for your Job, then click Finish.
Add the following components to your design workspace:
- A tFileInputRaw
- A tHMap
- Three tFileOutputRaw
Link the tFileInputRaw to the tHMap with a Row > Main connection.
Link the tHMap to the three tFileOutputRaw components with Row > Main connections, enter an name for the connection and click Yes when asked if you want to get the schema from the target component.
The name of the output connection must be the same as the name of the root element of the output in the flattening map. In this example, the connection names should be mondial_map_out_1, mondial_map_out_2 and mondial_map_out_3.
Double-click the tFileInputRaw and click the ... button to the right of Filename to select your input file, then select UTF-8 in the Encoding drop-down list.
Click the tHMap component and open the Component tab.
In the Map Path field, select the flattening map that you created.
Double-click the tFileOutputRaw components, enter the filename for each output file to create and select UTF-8 in the Encoding drop-down list.
In this example, the files are named C:/Users/jsmith/Documents/countries.csv, C:/Users/jsmith/Documents/cities.csv and C:/Users/jsmith/Documents/provinces.csv
Open the Run tab and click Run.

The Job runs and the three files are created in the selected folder.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!