topic Re: XML with multiple child loop in Talend Studio

XML with multiple child loop

Anonymous — Tue, 05 Sep 2017 19:44:06 GMT

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?

Re: XML with multiple child loop

Anonymous — Wed, 06 Sep 2017 09:04:28 GMT

Hello,

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

Best regards

Sabrina

Re: XML with multiple child loop

Anonymous — Wed, 06 Sep 2017 15:23:52 GMT

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

Re: XML with multiple child loop

Anonymous — Thu, 07 Sep 2017 14:56:03 GMT

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

Re: XML with multiple child loop

Anonymous — Thu, 07 Sep 2017 15:35:31 GMT

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.

XML.JPG