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