I am new to Talend, I have a requirement as I have to read data from Header and Details table and read those data into xml file. my Details table can have multiple records for a particular Header data.While sending the XML, I need to split the XML file based on the recors (for each Header records, need to send separate file and assign the file name from the field from Header table named XmlFile name as well).
My table data looks like
I have used a Job with tMssqlInput --> tMap--> tAdvancedFileOutputXML.
I have created a metadata for the xml file and given the header node as group element and Line element as loop element. and set the split property of the tAdvancedfile outputxml with 1 record I am getting the output as
if I will not set the split property the out put will be
But I need the out put as below:
could you some one please help me to achive this.
Thanks in advance
Solved! Go to Solution.