Xml fields joining

Six 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>

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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch