Joining data by using multiple look up in txmlmap

[Anonymous]

Dear all experienced users,

Can you kindly advice me simplest approach(i.e job design) to solve this case with right components for use?                   

I am a new user on business side with little knowledge of this tool. (Self-learner by trial and error and reading reference here) and I am looking for your kind advice to create the following data structure with data sourced from multiple look up in nested XML format.

I appreciate your valuable input and generous helping hands.   

Regards,

Yoshi

<My goal>

What I am trying is to combine all of data into 1 per Account.

<My problem>

I can't create multiple loops and group to capture data from 5 different look ups into relevant nodes.

I could do this with Account Info and Position.  1 look up only.  When adding more than 1 look up, I am not able to add loops anymore.Some people mentioned that it is not allowed by design of txmlmap function.  

If so, how can I solve this issue?   I could generate all of 5 xml files (Position, AssetFlow, CashFlow, DistributionFlow, and Orderflow) with data separately.

I read and tried tfileoutputMSXML with my CSV files, but i can't solve it too.  https://community.talend.com/t5/Design-and-Development/Multiple-child-loops-need-to-be-grouped-in-tX...

I also noted that some users says that txmp map doesn't allow us to add multiple loops and group.  Only 1 loop and 1 group.  If so, the following job design requires a whole new design with different components.

<Job Design>

<Output file structure>

[Anonymous]

Hello,

Is this topic Ok with you?

https://community.talend.com/t5/How-Tos-and-Best-Practices/prepare-XML-with-multiple-loop-in-same-le...

Any update for your issue?

Best regards

Sabrina

[Anonymous]

Hello, Sabrina,

Thanks for suggesting the link for possible solution.  I reviewed it including attachments with Project, but, this solves part of my issue.

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)

The following Group and Loop are not allowed due to tXMLmap design/limitation.

     Transactions (Group)

           importAssetFlow (Loop Element)

           importCashFlow (Loop Element)

           importDistributionFlow (Loop Element)

           importOrderFlow (Loop Element)