topic Re: How to create tXMLMap nested loops in Talend Studio

How to create tXMLMap nested loops

Anonymous — Sat, 16 Nov 2024 07:03:46 GMT

I have the below flow, and I would like the userGroup to be a loop as well according to data that's coming from another database lookup, Can you point me to the best way to approach this, I'm not able to do it right now.

Your help is appreciated.

Re: How to create tXMLMap nested loops

Anonymous — Thu, 13 Dec 2018 15:28:03 GMT

Good morning,

Can you guys help with this.

Thanks!

Re: How to create tXMLMap nested loops

Anonymous — Sun, 16 Dec 2018 02:08:07 GMT

Can anyone please help with this?

Thank you!

Re: How to create tXMLMap nested loops

Anonymous — Wed, 19 Dec 2018 23:11:36 GMT

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

But the problem is when it gets to the lookup part it won't bring all the user groups, it will bring only one row.

here is the flow:

here is the tCMLMap_3:

Here is the tMap_1

Here is the expression to replace the string:

row10.userGroup==null?
row9.payload.replaceAll("<UserGroups>WIRECODE_PLACEHOLDER</UserGroups>", "")
:row9.payload.replaceAll("<UserGroups>WIRECODE_PLACEHOLDER</UserGroups>", row10.userGroup)

Here is tTeradataInput_2:

Here is the resulted user node in the XML:

Here is the expected user groups:

is there something wrong with the way I do the join?

Your help appreciated!

Re: How to create tXMLMap nested loops

Anonymous — Fri, 04 Jan 2019 22:55:50 GMT

This is resolved using the solution in this link https://community.talend.com/t5/How-Tos-and-Best-Practices/prepare-XML-with-multiple-loop-in-same-level/m-p/142728#M729