Question Re: Mapping problem. in Technology Q&A

Mapping problem.

Former Member — Mon, 12 May 2008 09:43:19 GMT

I have a problem with getting the mapping rigth.

I have the following source message:

<?xml version="1.0" encoding="UTF-8"?>

<ns0:rtptest xmlns:ns0="http://">
   <messNo>123</messNo>
   <P01>
      <radNo>1</radNo>
      <P05>
         <P05data>11</P05data>
      </P05>
      <PXX>
         <PXXdata>111</PXXdata>
      </PXX>
   </P01>
   <P01>
      <radNo>2</radNo>
      <PXX>
         <PXXdata>222</PXXdata>
      </PXX>
   </P01>
   <P01>
      <radNo>3</radNo>
      <P05>
         <P05data>33</P05data>
      </P05>
      <PXX>
         <PXXdata>333</PXXdata>
      </PXX>
   </P01>
</ns0:rtptest>

The result should lokk in this way:

<?xml version="1.0" encoding="UTF-8"?>

<ns0:rtptest xmlns:ns0"http://">
   <messNo>123</messNo>
   <P01>
   <radNo>1</radNo>
      <PXX>
      <PXXdata>111</PXXdata>
      </PXX>
   </P01>
   <P01>
   <radNo>2</radNo>
      <PXX>
      <PXXdata>222</PXXdata>
      </PXX>
   </P01>
   <P01>
   <radNo>3</radNo>
      <PXX>
      <PXXdata>333</PXXdata>
      </PXX>
   </P01>
   <P01>
   <radNo>1</radNo>
      <P05>
      <P05data>11</P05data>
      </P05>
   </P01>
   <P01>
   <radNo>3</radNo>
      <P05>
      <P05data>33</P05data>
      </P05>
   </P01>
</ns0:rtptest>

But we get the following result:

<?xml version="1.0" encoding="UTF-8"?>

<ns0:rtptestxmlns:ns0="http://">
<messNo>123</messNo>
   <P01>
   <radNo>1</radNo>
      <PXX>
      <PXXdata>111</PXXdata>
      </PXX>
   </P01>
   <P01>
   <radNo>2</radNo>
      <PXX>
      <PXXdata>222</PXXdata>
      </PXX>
   </P01>
   <P01>
   <radNo>3</radNo>
      <PXX>
      <PXXdata>333</PXXdata>
      </PXX>
   </P01>
   <P01>
   <radNo>1</radNo>
      <P05>
      <P05data>11</P05data>
      </P05>
   </P01>
   <P01>
   <radNo>2</radNo>
   </P01>
   <P01>
   <radNo>3</radNo>
      <P05>
      <P05data>33</P05data>
      </P05>
   </P01>
</ns0:rtptest>

Ass you sse we get an extra P01 with <radNo>2</radNo> in it.

Thatone should not come. When we get this result we have P01 from the source mapped to P01 in the target.

I've tried to use P05 with the context set to rtptest to push the P01 but then we get the following result.

<?xml version="1.0" encoding="UTF-8"?>

<ns0:rtptest xmlns:ns0="http://">
<messNo>123</messNo>
   <P01>
   <radNo>1</radNo>
      <PXX>
      <PXXdata>111</PXXdata>
      </PXX>
   </P01>
   <P01>
   <radNo>2</radNo>
      <PXX>
      <PXXdata>222</PXXdata>
      </PXX>
   </P01>
   <P01>
   <radNo>3</radNo>
      <PXX>
      <PXXdata>333</PXXdata>
      </PXX>
   </P01>
   <P01>
   <radNo>1</radNo>
      <P05>
      <P05data>11</P05data>
      </P05>
   </P01>
   <P01>
   <radNo>2</radNo>
   </P01>
</ns0:rtptest>

We are still getting the P01 with <radNo>2</radNo> but not the last one.

I want the P01 with <radNo>2</radNo> to not be pushed and the last P01 to be ther when I have data in P05.

Does anybody know how I can solve this?

Kalle

Re: Mapping problem.

Former Member — Mon, 12 May 2008 11:39:10 GMT

Hi Kalle,

Check wheater the Occurence given is correct or not .........do let me know ............!

Regards,

Azeez khan.

Re: Mapping problem.

Former Member — Mon, 12 May 2008 11:59:34 GMT

This is how my source message looks:

<rtptest>     1...1
<messNo>     0...1
   <P01>     0...unbounded
   <radNo>     0...1
      <P05>     0...unbounded
      <P05data>     0...1
      <PXX>     0...unbounded
      <PXXdata>     0...unbounded

And this is how my target message looks:


<rtptest>     1...1
<messNo>     0...1
   <P01>     0...unbounded
   <radNo>     0...1
      <PXX>     0...unbounded
      <PXXdata>     0...unbounded
   <P01>     0...unbounded
   <radNo>     0...1
      <P05>     0...unbounded
      <P05data>     0...1

Re: Mapping problem.

Former Member — Mon, 12 May 2008 12:13:30 GMT

Hi Kalle,

I hope i've understood your requirement correctly. As per what i've made out of it, you could map the second P01 node as follows:

Use an "if-without-else" function. Change its property to "true".

Now take source side P05data (change its context to P01), a Constant = blank and put them on an EqualsS function. Add a boolean Not after EqualsS and put this on the IF part.

For the Then part put P01 with no context change.

Hope this works out for you.

Do reward points if the solution is helpful.

Regards,

Lavita.

Re: Mapping problem.

Former Member — Mon, 12 May 2008 12:19:02 GMT

Sorry get errormessage with that configuration.

Re: Mapping problem.

Former Member — Mon, 12 May 2008 12:21:12 GMT

Hi,

It would be helpful if you post in the error here.. Could try solving it perhaps.

Regards,

Lavita.

Re: Mapping problem.

GabrielSagaya — Mon, 12 May 2008 12:23:49 GMT

PXXDATA EQUALS CONSTANT ("") -> NOT -> IFWITHOUTELSE->

REMOVECONTEXT->COLLAPSECONTEXT->SPLITBY VALUE(value change)->P01

radno-->radno

pxxdata->pxxdata

checking whether source data exist then create target parent node wrt source node.

Re: Mapping problem.

Former Member — Mon, 12 May 2008 12:24:49 GMT

Missconfiguration of me used equales instead of equaless.

But when I do your config then I don't get the second P01 at all.

Tried with true and false as propertie in the if without else.

Re: Mapping problem.

Former Member — Mon, 12 May 2008 12:29:11 GMT

Yes,

You need to use EqualsS from the TEXT functions.

Is the context changed? Try adding Split by value after the if-without-else.

Do let me know if it works

Regards,

Lavita

Re: Mapping problem.

Former Member — Mon, 12 May 2008 12:29:32 GMT

That config only gets me the first of the second P01.

Re: Mapping problem.

Former Member — Mon, 12 May 2008 12:30:53 GMT

Same result.

Re: Mapping problem.

Former Member — Mon, 12 May 2008 12:33:37 GMT

Change the context of P05data to mesNo.

See if it works.

Regards,

Lavita

Re: Mapping problem.

Former Member — Mon, 12 May 2008 12:35:39 GMT

Changed the context for P05 to rtptest. Got the same result.

mesNo are a field.

Re: Mapping problem.

Former Member — Mon, 12 May 2008 12:38:04 GMT

Change it to P01.

Think that should work.

Regards,

Lavita

Re: Mapping problem.

Former Member — Mon, 12 May 2008 12:39:01 GMT

That gives the same result.

Re: Mapping problem.

Former Member — Tue, 13 May 2008 05:01:11 GMT

Hi,

I did the mapping with your given structures and this is how it should be mapped.

Source Structure and Target Structures are:

rtptest

--> mesNo

--> P01

> radNo

> P05

> P05data

> PXX

> PXXdata

Now while you map them,

on the target side, duplicate P01 node and map as follows:

For the first P01 node, you map it using the IF-without-ELSE node.

Now take source side PXXdata (change its context to MT), a Constant with no value and put them on an EqualsS function. Add a boolean Not after EqualsS and put this on the IF part.

For the Then part put PXX (change its context to MT).

For the second P01 node, you map it using the IF-without-ELSE node.

Now take source side P05data (change its context to MT), a Constant with no value and put them on an EqualsS function. Add a boolean Not after EqualsS and put this on the IF part.

For the Then part put P05 (change its context to MT).

Map the rest of the functions as they are i.e. 1:1 mapping of radNo, etc

Regards,

Lavita.

P.S. Do reward points if the solution works for you.

Re: Mapping problem.

Former Member — Tue, 13 May 2008 05:30:15 GMT

Hi.

I just tried your config with this message.

<?xml version="1.0" encoding="UTF-8"?>

<ns0:rtptest xmlns:ns0="http://">
   <messNo>123</messNo>
   <P01>
      <radNo>1</radNo>
      <P05>
         <P05data>11</P05data>
      </P05>
      <PXX>
         <PXXdata>111</PXXdata>
      </PXX>
   </P01>
   <P01>
      <radNo>2</radNo>
      <PXX>
         <PXXdata>222</PXXdata>
      </PXX>
   </P01>
   <P01>
      <radNo>3</radNo>
      <P05>
         <P05data>33</P05data>
      </P05>
      <PXX>
         <PXXdata>333</PXXdata>
      </PXX>
   </P01>
</ns0:rtptest>

The result I get are

<?xml version="1.0" encoding="UTF-8"?>
<ns0:rtptest xmlns:ns0="http://">
   <messNo>123</messNo>
   <P01>
   <radNo>1</radNo>
      <PXX>
      <PXXdata>111</PXXdata>
      </PXX>
   </P01>
   <P01>
   <radNo>2</radNo>
      <PXX>
      <PXXdata>222</PXXdata>
      </PXX>
   </P01>
   <P01>
   <radNo>3</radNo>
      <PXX>
      <PXXdata>333</PXXdata>
      </PXX>
   </P01>
   <P01>
   <radNo>1</radNo>
      <P05>
      <P05data>11</P05data>
      </P05>
   </P01>
   <P01>
   <radNo>2</radNo>
   </P01>
</ns0:rtptest>

The result I want are

<?xml version="1.0" encoding="UTF-8"?>
<ns0:rtptest xmlns:ns0="http://">
   <messNo>123</messNo>
   <P01>
   <radNo>1</radNo>
      <PXX>
      <PXXdata>111</PXXdata>
      </PXX>
   </P01>
   <P01>
   <radNo>2</radNo>
      <PXX>
      <PXXdata>222</PXXdata>
      </PXX>
   </P01>
   <P01>
   <radNo>3</radNo>
      <PXX>
      <PXXdata>333</PXXdata>
      </PXX>
   </P01>
   <P01>
   <radNo>1</radNo>
      <P05>
      <P05data>11</P05data>
      </P05>
   </P01>
   <P01>
   <radNo>3</radNo>
      <P05>
      <P05data>33</P05data>
      </P05>
   </P01>
</ns0:rtptest>

Do you have any idea on how to get this result?

Kalle

Re: Mapping problem.

Former Member — Tue, 13 May 2008 05:43:07 GMT

Hi...

You can do one thing... Use duplicate subtree in the target message... so you will be able to map PO5 and PXXData fields.

Also use "createif" function for radNo with a check that if PO5/PXX (to whichever subtree u are referring) exists create radNo node.

Re: Mapping problem.

Former Member — Tue, 13 May 2008 05:50:50 GMT

Trying to understand how the creatif works.

Looking at [http://help.sap.com/saphelp_nw70/helpdata/EN/d9/3033f96c79674f90e3ab8d101a595b/frameset.htm|http://help.sap.com/saphelp_nw70/helpdata/EN/d9/3033f96c79674f90e3ab8d101a595b/frameset.htm]

Do not understand how to make the test with createif.

If that function works as I think it do then that could be the solution.

Can you please make an example on how to use it in the configuration and how to connect it?

Re: Mapping problem.

Former Member — Tue, 13 May 2008 05:55:45 GMT

Hi,

This is the input


   <mesNo/>
   <P01>
      <radNo>1</radNo>
      <P05>
         <P05data>11</P05data>
      </P05>
      <PXX>
         <PXXdata>111</PXXdata>
      </PXX>
   </P01>
   <P01>
      <radNo>2</radNo>
      <P05>
         <P05data/>
      </P05>
      <PXX>
         <PXXdata>222</PXXdata>
      </PXX>
   </P01>
   <P01>
      <radNo>3</radNo>
      <P05>
         <P05data>33</P05data>
      </P05>
      <PXX>
         <PXXdata>333</PXXdata>
      </PXX>
   </P01>
</ns0:MT_TRY>

and here's the result, after the mapping i told you in the previous reply.


mesNo>
</mesNo>
<P01>
    <radNo>1</radNo>
    <PXX>
        <PXXdata>111</PXXdata>
    </PXX>
</P01>
<P01>
     <radNo>2</radNo>
     <PXX>
        <PXXdata>222</PXXdata>
     </PXX>
</P01>
<P01>
      <radNo>3</radNo>
      <PXX>
          <PXXdata>333</PXXdata>
      </PXX>
</P01>
<P01>
       <radNo>1</radNo>
       <P05>
            <P05data>11</P05data>
       </P05>
</P01>
<P01>
       <radNo>3</radNo>
       <P05>
            <P05data>33</P05data>
       </P05>
</P01>
</ns0:MT_TRY>

I think this is exactly what you are looking for.

Regards,

Lavita