Grphical mapping issue

[Former Member]

Hi guys,

we have a following mapping requirement;

INPUT XML;

 
<MT_A> 
   <HEADER>
       <CUSTOMER>1001</CUSTOMER>
       <DATE>09092011</DATE>
   </HEADER>
   <POSITION>
      <ITEM>
             <POSITION>001</POSITION>
             <NAME>APPLE</NAME>
             <AMOUNT>100</AMOUNT>
      </ITEM>
       <ITEM>
             <POSITION>002</POSITION>
             <NAME>BANANA</NAME>
             <AMOUNT>200</AMOUNT>
      </ITEM>
   </POSITION>
</MT_A> 

needed Output file;

 
<MT_B> 
   <ORDER>
       <ITEM>
            <CUSTOMER>1001</CUSTOMER>
            <DATE>09092011</DATE>
            <POSITION>001</POSITION>
            <NAME>APPLE</NAME>
            <AMOUNT>100</AMOUNT>
      </ITEM>
       <ITEM>
           <CUSTOMER>1001</CUSTOMER>
           <DATE>09092011</DATE>
            <POSITION>002</POSITION>
            <NAME>BANANA</NAME>
            <AMOUNT>200</AMOUNT>
      </ITEM>
</ORDER>
</MT_B> 

As above described we need to map the Header lines to the Item level on reciever side. Currently we have a following result;

 
<MT_B> 
   <ORDER>
       <ITEM>
            <CUSTOMER>1001</CUSTOMER>
            <DATE>09092011</DATE>
            <POSITION>001</POSITION>
            <NAME>APPLE</NAME>
            <AMOUNT>100</AMOUNT>
      </ITEM>
       <ITEM>
             <POSITION>002</POSITION>
            <NAME>BANANA</NAME>
            <AMOUNT>200</AMOUNT>
      </ITEM>
</ORDER>
</MT_B> 

I hope you can help me to solve this.

Kind Regards,

PM

[Former Member · Accepted solution]

use "USEONEASMANY" function...

CUSTOMER-------
ITEM-----------------------------USEONEASMANY-----CUSTOMER(Target)
POSITION(field under ITEM)----

[Former Member · Accepted solution]

Thanks, Points rewarded.