Five Stars PK
Five Stars

Generate single bulk xml file

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 jobInput to the job

 

output xml sampleoutput xml sample

 

Regards

PK

  • Data Integration
Tags (1)
3 REPLIES
Eleven Stars

Re: Generate single bulk xml file

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

Rilhia Solutions
Five Stars PK
Five Stars

Re: Generate single bulk xml file

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

PK

 

Eleven Stars

Re: Generate single bulk xml file

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.

Rilhia Solutions