The Append the source XML file feature
The Append the source xml file feature provided by the tAdvancedFileOutputXML component appends records to an existing XML file. This feature also resolves the can't create multiple loop elements on tAdvancedFileOutputXML at a time limitation: you can output one entity to an XML file first and append another entity to the existing XML file with this feature.
This scenario first generates an XML file using the data in the following tables.
Person
| Class_id | Person_id | Name |
|---|---|---|
| 1 | 1 | Shong |
| 1 | 2 | Elisa |
| 2 | 1 | Sabrina |
| 2 | 2 | Patrick |
Item
| Class_id | Person_id | Name |
|---|---|---|
| 1 | 1 | item1 |
| 1 | 2 | item2 |
| 2 | 1 | item3 |
The Job reads the above data and generate the following XML file.
Information noteTip: From the above XML, you
can see that there are two loop elements in the file: person and item. However, the
tAdvancedFileOutputXML component does not
allow to set multiple loop elements at a time. As a workaround, you can use the
Append the source xml file feature of the
tAdvancedFileOutputXML to avoid this
restriction and solve the problem.