Input XML having multiple values in the same tag

[Former Member]

Hi,

In my scenario, my input XML is in the following format...

<Product>

<Site_ID>A1, A2, A3</Site_ID>

<SIte_Name>ABC, XYZ, PQR</Site_Name>

</Product>

A1 corresponds to ABC

A2 corresponds to XYZ and so on...

Is there some way to retrieve values from such a source file and then map it to the target

i.e A1 ABC has to go as one record

A2 XYZ has to go as a second record and so on..

Thanks in advance,

Regards,

Karen

[athavanraja]

using xslt you can retrive Site_ID values and Site_name and then you have to use your own abap logic to split the values.

for example

site_name = 'A1, A2, A3, A4' .

then you can use split site_name at ',' into table <itab>

[Former Member]

Hi Durairaj,

Can i do this in the message mapping tool??

Regards,

Karen Pereira

[athavanraja]

<i>Can i do this in the message mapping tool??</i>

i guess you mean XI.

yes, but you may have to write a custom function do this kind of mapping

[Former Member]

yes.. i have to do this in XI...

Thanks,

Karen

[Former Member]

Did it using a a custom UDF

Regards,

Karen