Five Stars

Xml fields joining

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>

1 REPLY
Moderator

Re: Xml fields joining

Hello,

The tFileOutputMSXML component allows to loop the child elements.

Please refer to online component reference about:TalendHelpCenter:tFileOutputMSXML

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.