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
Talend named a Leader.
Kickstart your first data integration and ETL projects.
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