Talend Data Mapper xml input - looking up values in a separate loop

Anonymous — Fri, 23 Mar 2018 00:24:33 GMT

hi! I have an xml file similar to the following:

</travelSegment>

</travelDetail>

To create my JSON output, I loop over the travelSegments with the profileReferences nested, and build separate transactions for each profile reference like:

"travelData":[

{"type":"AIR",

"name":"Henry",

"price":205.55,

"currency":"USD"

{"type":"AIR",

"name":"Bob",

"price":205.55,

"currency":"USD"

}

I've got the thmap generating

"travelData":[

{"type":"AIR",

"profileId":2,

"price":205.55,

"currency":"USD"

{"type":"AIR",

"profileId":3,

"price":205.55,

"currency":"USD"

}

How do I lookup the profile reference id in the Profiles array to get the name corresponding to the profileReference id?

I have tried many things including AgConcatFirstPresentValue, but it always grabs just the first value even if I filter the Profiles loop by the id = ProfileReference (at least for the ids included in the profileReference). Is there a way to get just the profile with the id in the 2nd loop?

thank you!

Re: Talend Data Mapper xml input - looking up values in a separate loop

Anonymous — Fri, 23 Mar 2018 08:22:41 GMT

Hi,

I used a set variable:

Then I get this variable:

I uploaded my map.

Let me know if it meets your requirements.

Regards.

Eric

TRAVEL_MAP.zip

Re: Talend Data Mapper xml input - looking up values in a separate loop

Anonymous — Fri, 23 Mar 2018 17:21:22 GMT

Thank you! It worked like a charm.

topic Talend Data Mapper xml input - looking up values in a separate loop in Talend Studio

Talend Data Mapper xml input - looking up values in a separate loop

Re: Talend Data Mapper xml input - looking up values in a separate loop

Re: Talend Data Mapper xml input - looking up values in a separate loop