Xml fields joining

[Anonymous]

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>

<TestCode>5A</TestCode>

<TestName>RFCA</TestName>

</Test>

</OTest>

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

<TestCode>5A</TestCode>

<TestName>RFCA</TestName>

<TestStatus>F</TestStatus>

<OTestCodeRefer>5A</OTestCodeRefer>

<ColV>700</ColV>

</Test>

[Anonymous]

Hello,

The tFileOutputMSXML component allows to loop the child elements.

Please refer to online component reference about:TalendHelpCenter:tFileOutputMSXML

Best regards

Sabrina