topic Re: Input XML having multiple values in the same tag in Application Development and Automation Discussions

Input XML having multiple values in the same tag

Former Member — Tue, 22 May 2007 09:38:49 GMT

Hi,

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

<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 — Tue, 22 May 2007 09:49:51 GMT

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 — Tue, 22 May 2007 10:25:08 GMT

Hi Durairaj,

Can i do this in the message mapping tool??

Regards,

Karen Pereira

athavanraja — Tue, 22 May 2007 10:30:22 GMT

<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 — Tue, 22 May 2007 10:46:32 GMT

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

Thanks,

Karen

Former Member — Fri, 27 Jun 2008 09:23:04 GMT

Did it using a a custom UDF

Regards,

Karen