topic Re: Generate single bulk xml file in Talend Studio

Generate single bulk xml file

Anonymous — Fri, 23 Jun 2017 10:35:34 GMT

Hi,

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.

Input to the job

output xml sample

Regards

Re: Generate single bulk xml file

Anonymous — Fri, 23 Jun 2017 11:14:10 GMT

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).

Re: Generate single bulk xml file

Anonymous — Fri, 23 Jun 2017 11:53:19 GMT

Hi,

Thanks for your reply.

I want entire set of xml in one file, in this case which element should i select for loop.

Thanks

Re: Generate single bulk xml file

Anonymous — Fri, 23 Jun 2017 11:54:53 GMT

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.