Question Re: Split many elements in others many elements in Technology Q&A

Split many elements in others many elements

former_member200572 — Wed, 22 Apr 2009 15:42:28 GMT

Hi folks.

I have to follow source XML to map to receiver XML:


source
....
<SERVICE>
  <SRVNR>1001</SRVNR>
  <MATERIAL>
    <MATNR>QWERT</MATNR>
  </MATERIAL>
  <MATERIAL>
    <MATNR>ASDFG</MATNR>
  </MATERIAL>
</SERVICE>
<SERVICE>
  <SRVNR>2002</SRVNR>
</SERVICE>
<SERVICE>
  <SRVNR>3003</SRVNR>
  <MATERIAL>
    <MATNR>ZXCVB</MATNR>
  </MATERIAL>
</SERVICE>
....

receiver must be as follow
....
<MATERIAL>
  <SRVNR>1001</SRVNR>
  <MATNR>QWERT</MATNR>
</MATERIAL>
<MATERIAL>
  <SRVNR>1001</SRVNR>
  <MATNR>ASDFG</MATNR>
</MATERIAL>
<MATERIAL>
  <SRVNR>3003</SRVNR>
  <MATNR>ZXCVB</MATNR>
</MATERIAL>
....

but the result is below
<MATERIAL>
  <SRVNR>1001</SRVNR>
  <MATNR>QWERT</MATNR>
</MATERIAL>
<MATERIAL>
  <SRVNR>2002</SRVNR>
  <MATNR>ASDFG</MATNR>
</MATERIAL>
<MATERIAL>
  <SRVNR>3003</SRVNR>
  <MATNR>ZXCVB</MATNR>
</MATERIAL>

I've tried the code below:


 for (int i=0; i<a.length;i++){
  result.addValue(b[0]);
}

where the parameter a is my root <MATERIAL> and the parameter b is element <SRVNR>, but the result is wrong.

I've tried node function useOneAsMany but doesn't work too.

My difficult is associate root <SERVER> with corresponding roots <MATERIAL> in the result using either a node function or an user define function.

Someone can help me, please?

Thanks in advanced.

Re: Split many elements in others many elements

Former Member — Wed, 22 Apr 2009 17:38:51 GMT

under node functions you can use 'split by value' on 'vale change' for SRVNR...

Re: Split many elements in others many elements

former_member200572 — Wed, 22 Apr 2009 18:20:05 GMT

Hi Prema.

I've done your tip but doesn't work.

Thanks

Re: Split many elements in others many elements

Former Member — Wed, 22 Apr 2009 19:02:14 GMT

Make sure your UDF is context type.

I do not see any reason why useOneAsMany does not work.

Liang

Edited by: Liang Ji on Apr 22, 2009 9:02 PM

Re: Split many elements in others many elements

Former Member — Wed, 22 Apr 2009 19:35:41 GMT

can you change the context of MATNR to SERVICE..

Re: Split many elements in others many elements

Former Member — Wed, 22 Apr 2009 20:51:08 GMT

I got a answer for you... replicated same scenario in my IR, could test that and it is working great..

do you want me to send screen shots? or I can explain it to you..

fields are mapped like this;

Step 1)

MATNR ---> removeContexts --->MATERIAL

where MATNR context is changed to SERVICE

Step 2)

SRVNR -

MATERIAL -

MATNR -

in the same order all 3 fields go to -

> useOneAsMany -

> SplitByValue(Each Value) -

> SRVNR

again MATNR context is changed to SERVICE

Step 3)

MATNR ---> SplitByValue(Each Value) -

>MATNR

again MATNR context is changed to SERVICE ..

this should work for you.. please do try.. I have invested time to do this )

Re: Split many elements in others many elements

former_member200572 — Thu, 23 Apr 2009 19:27:46 GMT

Hi Prema.

I delayed to answer to you because your tip is was almost what I needed, but with it I got the solution.

I've never done an useOneAsMany function with a context instead of elements as you suggest.

My scenario it was a little more complex then I wrote, but now it's solved.

Thank you so much for the tip!

Re: Split many elements in others many elements

Former Member — Thu, 23 Apr 2009 19:42:59 GMT

You are very welcome.. Happy that it worked for you..

Re: Split many elements in others many elements

Former Member — Tue, 28 Apr 2009 14:54:12 GMT

Edited by: Wolfgang Disch on Apr 28, 2009 5:45 PM

Re: Split many elements in others many elements

Former Member — Tue, 28 Apr 2009 15:30:04 GMT

Edited by: Wolfgang Disch on Apr 28, 2009 5:30 PM

Edited by: Wolfgang Disch on Apr 28, 2009 5:45 PM