Repeating the Values

[Former Member]

Hi All,

I have target structure filed should repeat based on source values.

Soure Structure

-

---

IDOC

E1P0105

personal Number : 001

TelePhone : 987-456-1234

USERID_LONG : gggg

E1P0105

personal Number : 001

TelePhone :890-123-3456

USERID_LONG :iiiii

E1P0105

personal Number :001

TelePhone :786-1234-0011

USERID_LONG :eeeee

Target Structure

-

---

Person(0:U)

person(1:1)

Contact Value(1:1)-->it should have Telephone and USERID_LONG values.

Hoe do I get all contact values in one target node. Please share your experienc eon this...

Thanks,

Shankar

[Former Member · Accepted solution]

Do you mean all values belonging to one particular personal number shall be concatenated into one target field?

Can you give an example of your desired output?

[Former Member · Accepted solution]

thanks for looking my thread..any way i resolved this..tweaking with some graphical functions..

output is :

personl number(1:1)

contact values(N:1)

Thanks,

Shankar

[Former Member]

Shankar,

For a structure such as this,

<CONTACTS>

<DETAILS>

<NAME>t</NAME>

<PHONE>1</PHONE>

</DETAILS>

<DETAILS>

<NAME>t</NAME>

<PHONE>2</PHONE>

</DETAILS>

</CONTACTS>

If you are looking for an output such as this,

<EMP>

<CONTACTS>

<NAME>t</NAME>

<MOBILE>1</MOBILE>

<MOBILE>2</MOBILE>

</CONTACTS>

</EMP>

Then you would first need to map contacts to the contacts node, secondly you will need to move the context of phone to contacts, use the node function remove context and map it to mobile.