Mapping Requirement for Multiple Source Occurences

[former_member192105]

I have a mapping requirement as shown in the image below.
Row and Segment01 can occur multiple times (0..Unbounded). I tried changing context of Segment01 node to get the output but it did not work.

How to achieve this logic with Message Mapping?

~Thank you.

[former_member192105]

Hello Experts,
Any assistance on above mapping logic?
Thanks in advance for your contribution.

[former_member192105]

Hello Manoj,

I tried with the mapping logic mentioned above but it did not work for me.
Context of Source fields was set as Payment - Row , Identifier - Row , Currency - Row , User - DataRow

My requirement is there would be multiple occurrences of Row and each Row can contain multiple Segment01. It may happen that Segment01 has or does not have Currency = EUR.
Wherever, Currency = EUR matches, only those records should be passed to the target.
Expected Output is as shown below:

I tried with If-Else on the Row and Segment01 but that did not work.

Any idea how to proceed?

[manoj_khavatkopp]

That's should have been made clear in the initial question, i was under the impression of selecting segment which had max value in "Identifier" . But now i see you are selecting segment based on "EUR" , so the above logic which i have provided does not work for this.

[former_member192105]

Hello Manoj,
Sorry for the confusion. I missed giving the details earlier.

[former_member192105]

Hello Manoj,

First of all thank you for taking so much efforts!

I will implement this logic in the mapping and update the thread accordingly.

[manoj_khavatkopp]

Abhishek ,

Try this :

Set all the Source field context to one level higher.

Br,

Manoj