Muliple (different) source fields(1:N) to same target field(0:N) mapping

[Former Member]

Hi experts,

If possible please can you let me know if it is possible to map different source fields(1:N) to the same target field(0:N) based on specific conditions for example:

-apples(1:n)-->fruit(1:n)

pears(1:n)>fruit(1:n)

-peaches(1:n)>fruit(1:n)

i.e.

Source Message:

<Source>

<apples>red apples<apples>

<apples>green apples<apples>

<apples>yellow apples<apples>

<pears>red pears<pears>

<pears>green pears<pears>

<peaches>yellow peaches<peaches>

<peaches>red peaches<peaches>

<Source>

Required Target Message:

<Target>

<fruit>red apples<fruit>

<fruit>green apples<fruit>

<fruit>yellow apples<fruit>

<fruit>red pears<fruit>

<fruit>green pears<fruit>

<fruit>yellow peaches<fruit>

<fruit>red peaches<fruit>

<Target>

Is it possible to achieve the above mapping using the graphical mapping tool.

Any help would be appreciated very much.

Thank you,

Brendon

[Former Member · Accepted solution]

Hi Brendom

Yes you try this , on your target right click on the segment "fruit" and duplicated the segment two times and map with the source like this

apples------------>fruit
pears------------->fruit(1)
peaches------------->fruit(2)

Also you cand built and UDF function.

[Former Member · Accepted solution]

Hi Luis,

Thank you for the very helpful answer. I think this will solve the problem.

Thanks:-)

Brendon