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

[Anonymous]

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

<ProcessParsePriveReportDataResult>

         <ImportInvestorAccountUpdate>

                 <valueDate/>

                 <investorAccount>

                         <accountNumber>M2185</accountNumber>

                 </investorAccount>

                 <accountCurrency/>

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)?

[vapukov]

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

[Anonymous]

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

[Anonymous]

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)