cancel
Showing results for 
Search instead for 
Did you mean: 

Graphical mapping: flat structure to list

Former Member
0 Kudos

Hi,

Has anyone an idea for a graphical mapping ? The elements <phone1> and <phone2> should be trensfered to a list of <phone>

source:

<person_out>

<name>A</name>

<phone1>1</phone1>

<phone2>2</phone2>

</person_out>

target:

<person_in>

<name>A</name>

<phone>1</phone>

<phone>2</phone>

</person_in>

regards

Kerstin

Accepted Solutions (1)

Accepted Solutions (1)

former_member187339
Active Contributor
0 Kudos

Hi Kerstin,

Simple

In the Message mapping, right click the Phone field of target and choose duplicate subtree. the map each of phone1 and phone2 to them (one for each phone)

Regards

Suraj

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks guys

Former Member
0 Kudos

you can also create UDF with two arguments(phone1,phone2) and choose context


result.addValue(phone1[0])
result.addValue(phone2[0])

use as follows


phone1---->\
                      UDF----->phone(Target field)
phone2---->/

Former Member
0 Kudos

Hi,

you could right click on the target field phone and duplicate it.

Then you could map your input phone fields (1 and 2) to the target phone fields.

Regards

Patrick