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 ?
The tFileOutputMSXML component allows to loop the child elements.
Please refer to online component reference about:TalendHelpCenter:tFileOutputMSXML
Watch the recorded webinar!
Read about OTTO's experiences with Big Data and Personalized Experiences
Pick up some tips and tricks with Context Variables
Take a look at this video about Talend Integration with Databricks
Learn how<SPAN>to modernize your Cloud Platform for Big Data Analytics with Talend and Microsoft Azure</SPAN>