I have requirement to read the attributes from xml and generate the bulk single xml file for all the rows.I am able to create individual xml for each and every input records in xls file , but i do not know how to club togather all the xml in one bulk xml.
Can anyone help me to achieve this please.
Please find below sample of input data and output xml which i have generated using talend job.
You will need a looping element. With a looping element you can quite easily use the tXMLMap after ticking the "All in one" option in the tXMLMap output table config (the spanner).
You need to ensure your XML schema allows this (if it is not owned by you) or add a looping element to surround your data that repeats.