Need a Graphical Mapping solution for the following requirement!!

[Former Member]

Hello Every One,

Greetings for the day!!

I need a graphical mapping solution for the following requirement. Here are the below details.

<span style="font-size: 12pt;">Source Structure:</span>

<span style="font-size: 12pt;">MT_Source:</span>

<span style="font-size: 12pt;">     |__</span>HEADER(1:Unbounded)

*               </span><span style="font-size: 10pt;">|___ Field1</span></p><p><span style="font-size: 10pt;">               |___Field2</span></p><p><span style="font-size: 10pt;">               |___*Field3

     *

ITEM(1:Unbounded)</strong></span></p><p><span style="font-size: 10pt;">               |___ Field1</span></p><p><span style="font-size: 10pt;">               |___Field2</span></p><p><span style="font-size: 10pt;">               |___Field3</span></p><p><span style="font-size: 10pt;">
</span></p><p><span style="font-size: 10pt;">*</span>In my above Case, both HEADER and ITEM lie under same hierarchy of Message Type. Now I need my output target XML structure like as follows.

<span style="font-size: 12pt;">MT_Target:</span>

<span style="font-size: 12pt;">     |__</span>HEADER(1:Unbounded)

*               </span><span style="font-size: 10pt;">|___ Field1</span></p><p><span style="font-size: 10pt;">               |___Field2</span></p><p><span style="font-size: 10pt;">               |___*Field3

              *

ITEM(1:Unbounded)</strong></span></p><p><span style="font-size: 10pt;">                     |___ Field1</span></p><p><span style="font-size: 10pt;">                     |___Field2</span></p><p><span style="font-size: 10pt;">                     |___*Field3</span></p><p><span style="font-size: 10pt;"><br>The input XML structure incoming to Message Mapping after communication channel would be one header followed by some 'n'  number of items and again one header followed by 'n' number of items. Would request you to kindly provide me the graphical mapping solution for the same so that i can proceed further.</span></p><p><span style="font-size: 10pt;"><br></span></p><p><span style="font-size: 10pt;">Thanks in advance!!</span></p><p><span style="font-size: 10pt;"><br></span></p><p><span style="font-size: 10pt;"><br></span></p><p><!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG></o:AllowPNG> </o:OfficeDocumentSettings> </xml><![endif]></p><p><![if gte mso 9]><![endif]><![if gte mso 9]><![endif]><![if gte mso 10]>

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}

[Former Member · Accepted solution]

Hello Everyone,

Sorry for the mistake!!

Please find the details below.

Source Structures Header and Item at same parent hierarchy level:

Target Structures with Item inside the Header structure:

Source XML:

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

<ns0:MT_SalesOrder_File_Source xmlns:ns0="urn:test:prash">

   <Header>

      <TYP>T</TYP>

      <FFNR>3491000888</FFNR>

      <FF_BELEG>00033</FF_BELEG>

      <MAKTL>212356</MAKTL>

   </Header>

   <Item>

      <FFNR>3491000888</FFNR>

      <FF_BELEG>00033</FF_BELEG>

      <DATUM>26.07.2016</DATUM>

   </Item>

   <Item>

      <FFNR>3491000888</FFNR>

      <FF_BELEG>00033</FF_BELEG>

      <DATUM>26.07.2016</DATUM>

   </Item>

   <Header>

      <TYP>T</TYP>

      <FFNR>3491000888</FFNR>

      <FF_BELEG>00034</FF_BELEG>

      <MAKTL>412346</MAKTL>

   </Header>

   <Item>

      <FFNR>3491000888</FFNR>

      <FF_BELEG>00034</FF_BELEG>

      <DATUM>26.07.2016</DATUM>

   </Item>

   <Item>

      <FFNR>3491000888</FFNR>

      <FF_BELEG>00034</FF_BELEG>

      <DATUM>26.07.2016</DATUM>

   </Item>

</ns0:MT_SalesOrder_File_Source>

Target XML Output expected:

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

<ns0:MT_SalesOrder_File_Source xmlns:ns0="urn:test:prash">

   <Header>

      <TYP>T</TYP>

      <FFNR>3491000888</FFNR>

      <FF_BELEG>00033</FF_BELEG>

      <MAKTL>212356</MAKTL>

      <Item>

         <FFNR>3491000888</FFNR>

         <FF_BELEG>00033</FF_BELEG>

         <DATUM>26.07.2016</DATUM>

      </Item>

      <Item>

         <FFNR>3491000888</FFNR>

         <FF_BELEG>00033</FF_BELEG>

         <DATUM>26.07.2016</DATUM>

      </Item>

   </Header>

   <Header>

      <TYP>T</TYP>

      <FFNR>3491000888</FFNR>

      <FF_BELEG>00034</FF_BELEG>

      <MAKTL>412346</MAKTL>

      <Item>

         <FFNR>3491000888</FFNR>

         <FF_BELEG>00034</FF_BELEG>

         <DATUM>26.07.2016</DATUM>

      </Item>

      <Item>

         <FFNR>3491000888</FFNR>

         <FF_BELEG>00034</FF_BELEG>

         <DATUM>26.07.2016</DATUM>

      </Item>

   </Header>

</ns0:MT_SalesOrder_File_Source>

Kindly help on the same!!

Apologies for the earlier wrong post.

Thanks in advance!!

Many Thanks,

Best Regards,

Prashanth Bharadwaj Ch.

[former_member186851 · Accepted solution]

Hello Prashanth,

Create a target structure like below

Header

      TYP

      FFNR

      FF_BELEG

      MAKTL

      Item---       0---Unbounded

And map header and item fields directly,should work.

[manoj_khavatkopp · Accepted solution]

I guess you cant handle this IN graphical mapping.

Check this blog :

Or you may use Node Deception conecpt

[Former Member]

Hello Manoj,

Thanks alot for the answer.

Now it works!!

Thanks again!

Many Thanks,

Best Regards,

Prashanth Bharadwaj Ch.

[Former Member]

Hello Raghuraman,

Thanks for the reply.

There is only context for both Header and Item which MT_SalesOrder_File_Source.

Many Thanks,

Best Regards,

Prashanth Bharadwaj Ch.

[Former Member]

Hello Raghuraman,

Thanks for the reply!!!

I have created the same which is already mentioned in the screenshot. But unfortunately, it is not working.

Kindly help!!

Many Thanks,

Best Regards,

Prashanth Bharadwaj Ch.

[former_member186851]

Hello Prashanth,

Try changing the Item context as MT_SalesOrder_File_Source and try.

[former_member186851]

Hello Prashanth,

Requriement is bit confusing.

Post the input and required Output XML.