topic Without using Data Mapper (tHmap), how do I integrate 5 nested XML files into 1 nested XML file with multiple loops and groups in Talend Studio

Without using Data Mapper (tHmap), how do I integrate 5 nested XML files into 1 nested XML file with multiple loops and groups

Anonymous — Thu, 29 Nov 2018 02:16:01 GMT

I use open source version of Talend Open Studio, and I am trying to integrate 5 nested XML files into 1 nested XML file without using Data Mapper (tHmap)

How can I achieve it? tMap allows me to pair 1 group to 1 loop or multiple only.

Structure of 1 XML(main) and 5 XML files(Sub) are attached.

All of 5 XML has partially the same structure below.

Common structure

</investorAccount>

Main

Under Position, security and cash balance are stored. Data comes from Sub-Position

Under Transaction, 5 different types of transaction data are stored. Data comes from Sub-AssetFlow, Sub-CashFlow, Sub-DistributionFlow, and Sub-Order

I can achieve group and loop with one of 5 (position, assetflow, cashflow, distributionflow and Order), but I can't loop all of them according to the structure designed by using tmapxml.

It this achievable without using tHmap(Data mapper)?

Re: Without using Data Mapper (tHmap), how do I integrate 5 nested XML files into 1 nested XML file with multiple loops and groups

vapukov — Thu, 29 Nov 2018 04:33:11 GMT

any case is unique, but check ideas from here https://community.talend.com/t5/How-Tos-and-Best-Practices/prepare-XML-with-multiple-loop-in-same-level/m-p/142728#M729

Re: Without using Data Mapper (tHmap), how do I integrate 5 nested XML files into 1 nested XML file with multiple loops and groups

Anonymous — Thu, 29 Nov 2018 11:22:29 GMT

Dear Vapukov,

Thank you so much for your kind assistance. I will give it a try.

Finally, I have a clue to complete my case.

Regards,

Yoshi

Re: Without using Data Mapper (tHmap), how do I integrate 5 nested XML files into 1 nested XML file with multiple loops and groups

Anonymous — Tue, 04 Dec 2018 15:56:07 GMT

Dear Vapukov,

I reviewed your suggestion and uploaded the project file for further review. I realized that it refers to multiple loops without group and group element.

My XML file requires Group element, a few sets of Group and Loop. I can set only one Group and Loop element

i.e (This is what I want to achieve, but haven't achieved this)

ImporInvestAccountUpdate (Group Element)

Positions (Group)

importPosition (Loop)

Transactions (Group)

importAssetFlow (Loop Element)

importCashFlow (Loop Element)

importDistributionFlow (Loop Element)

importOrderFlow (Loop Element)

I can achieve this only with tXMLmap

ImporInvestAccountUpdate (Group Element)

Positions (Group)

importPosition (Loop)

or I can add either one of importAssetFlow/importCashFlow/importDistributionFlow/importOrder flow under transaction.

The following Group and Loop are not allowed due to tXMLmap design/limitation. Different account number contains different positions (Stock and Cash) as well as different transactions.

~~Transactions (Group)~~

~~importAssetFlow (Loop Element)~~

~~importCashFlow (Loop Element)~~

~~importDistributionFlow (Loop Element)~~

~~importOrderFlow (Loop Element)~~