Xml fields joining

Anonymous — Sat, 16 Nov 2024 08:48:08 GMT

I have a requirement where i have to join the multiple fields of an XML file to get valid data and store it into sql table. my Xml document looks like this. Here i have to join TestCode from[OTest] and OTestCodeRefer from [PTests] to get the complete data for that table. How this can be achieved ?

</OTest>

-<OTest>
-<Test>

</Test>

</OTest>

</OTests>
-<PTests>
-<PTest>
-<Test>

</Test>

Re: Xml fields joining

Anonymous — Mon, 05 Feb 2018 05:37:54 GMT

Hello,

The tFileOutputMSXML component allows to loop the child elements.

Please refer to online component reference about:TalendHelpCenter:tFileOutputMSXML

Best regards

Sabrina

topic Re: Xml fields joining in Talend Studio

Xml fields joining

Re: Xml fields joining