I need help to develop a job that generates a multi-loops XML.
the "decla" tag is repeated several times (loop) and contains the output 3 others loop-tags : "souscripteur", "assure" and "beneficiaire" (in yellow here after)
All the Talend Components support only one definited loop.
How can i do to obtain that structure ?
Thanks a lot for your answers
There are several ways to do this....
1) Use the Talend Data Mapper. But that is only available to the Enterprise Edition users....and is a bit funky if you are using it for the first time.
2) Use a bit of Java. Unfortunately the tXMLMap just won't cover this requirement on its own. But what you can do is create your base XML structure using a tXMLMap and then add to it using some Java (....my favourite approach).
3) Similar to the last approach, but instead of writing Java code to manipulate and add to DOM objects, you build your base XML structure and then build your sub-XML structures (your loops), convert everything to Strings and then carry out a find and replace to build up your final XML structure.
To be honest, they are all quite tricky at first. But once you figure out the structure and the method, it is actually quite methodical.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables