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.
For more technologies supported by Talend, see Talend components.
The Job reads the above data and generate the following XML file.
Tip: 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.