Five Stars

XML with multiple child loop

I have to process on xml with multiple child loop elements...could you please suggest design...currently Job is build in Abinitio and we are trying to convert it to Talend...in current job design...child loops are normalized one by one...how the design will look in Talend...I tried to create MetaData from XSD...what would be the XPath if need to process all child loop elements...can I do in one step or divide in steps?

Tags (1)
4 REPLIES
Moderator

Re: XML with multiple child loop

Hello,

Could you please elaborate your case with an example with input and expected output values?

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.
Employee

Re: XML with multiple child loop

Consider using Talend Data Mapper which is designed for arbitrary depth hierarchies.

Five Stars

Re: XML with multiple child loop

Thanks! Haven't used it before...let me try.
Five Stars

Re: XML with multiple child loop

PFA XML Sample. 

Parent loop is - MasterAgreement

Child Nodes are - SecurityAgreementList , MultibranchEntityList, FirmBranchesList 

Need to write data after normalizing to Oracle so scenario is if there are multiple records for first than I have to create those many rows...after that go to second child and again if there are multiple records...create those many rows and so on.