topic Joining data by using multiple look up in txmlmap in Talend Studio

Joining data by using multiple look up in txmlmap

Anonymous — Sat, 16 Nov 2024 07:14:29 GMT

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

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

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-tXMLMAP/m-p/57391

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.

Re: Joining data by using multiple look up in txmlmap

Anonymous — Fri, 30 Nov 2018 08:47:20 GMT

Hello,

Is this topic Ok with you?

https://community.talend.com/t5/How-Tos-and-Best-Practices/prepare-XML-with-multiple-loop-in-same-level/m-p/142728#M729

Any update for your issue?

Best regards

Sabrina

Re: Joining data by using multiple look up in txmlmap

Anonymous — Tue, 04 Dec 2018 15:49:55 GMT

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