Xml fields joining

Highlighted
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 Summer ’19

Watch the recorded webinar!

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now

How to Modernize Your Cloud Platform for Big Data Analytics With Talend and Micr...

Learn how<SPAN>to modernize your Cloud Platform for Big Data Analytics with Talend and Microsoft Azure</SPAN>

Read