topic Re: Advanced XML with different loops in Talend Studio

Advanced XML with different loops

Anonymous — Sat, 16 Nov 2024 13:39:23 GMT

Hello,
I have a scenario using XML files in which I have to set up something like this :
I have 3 data sources. Invoice_Header, Invoice_Line and Invoice_Line_Tax
My Invoice_Header schema is something like
ID,
TotalAmt,
Description
My Invoice_Line schema is something like
LineID,
HeaderID,
LineAmt
My Invoice_Line_Tax schema is something like
TaxID,
LineID,
TaxPerct,
TaxAmt
I would like to read the 3 separate tables and come up with one single XML at the end.
My problem is that I can't figure out a way to join the values because of different loops...for 1 invoice, I might have N lines, and for 1 Line I might have N Taxes
I've attached some handmade xml's that I'm working with to try to figure this out, there are the separated XML's and the final structure I would like to get to. It's something like this :
<Invoices>
<Invoice>
<ID/>
<TotalAmt/>
<Description/>
<InvoiceLines> /* Loop 1-N */
<Line>
<LineID/>
<LineAmt/>
<LineTaxes> /* Second Loop 1-N */
<Tax>
<TaxID/>
<TaxPerct/>
<TaxAmt/>
<Tax/>
</LineTaxes>
</Line>
</InvoiceLines>
</Invoice>
</Invoices>
Does anybody have any kind of ideas or something for me to try out ? I'm currently going for the tJava component and appending the strings for 3 different files into one...but that's obviously something I would like to avoid.
Thanks!

Re: Advanced XML with different loops

janhess — Mon, 07 Dec 2009 17:05:45 GMT

See https://community.talend.com/t5/Design-and-Development/resolved-tFileOutputMSXML/td-p/104703 for an answer. To merge the output in your tree style you need to have the non loop part the same in the multiple roots so that they can be matched. I think there is a better example from Shong but I couldn't find it.

Re: Advanced XML with different loops

Anonymous — Mon, 03 Mar 2014 16:17:37 GMT

Also have a look at these articles:
This one should answer to your needs:
Talend Tutorial - Advanced XML transformation ? Part 2 - table rows to XML http://makina-corpus.com/blog/metier/2014/talend-tutorial-advanced-xml-transformation-2013-part-2-table-rows-to-xml
And this other will do the opposed job: Talend Tutorial - Advanced XML transformation ? Part 1 - XML to table rows http://makina-corpus.com/blog/metier/2014/advanced-xml-transformation-2013-part-1-xml-to-table-rows