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.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download 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