AnsweredAssumed Answered

Map Join Different Levels Together

Question asked by jon.mayoh008888 on Dec 14, 2017
Latest reply on Dec 15, 2017 by leif_jacobsen
Hi

Has anyone got any ideas how to combine different levels in a map.  Previously I would have built an array but can’t seem to get this working in Boomi.

The issue is I need to combine different levels of data together into one line using the line number as a key on the output side of the map. Here is the simplified data.
Input Side of Map Contains these segments which can loop:-

<E1EDL24>
     <POSNR>00001</POSNR>
     <VFDAT>20181211</VFDAT>
</E1EDL24>
<E1EDL24>
     <POSNR>00002</POSNR>
     <VFDAT>20181212</VFDAT>
</E1EDL24>
<E1EDL37>
     <POSNR>00001</POSNR>
     <MATNR>ABC</MATNR>
</E1EDL37>
<E1EDL37>
     <POSNR>00002</POSNR>
     <MATNR>DEF</MATNR>
</E1EDL37>
Output Side Should Contains these segments: -
 <RCTLIN>
  
<LINE>00001</LINE>
  <MATNR>ABC</MATNR>
   <VFDAT>20181211</VFDAT>
</RCTLIN>
<RCTLIN>
   <LINE>00002</LINE>
   <MATNR>DEF</MATNR>
   <VFDAT>20181212</VFDAT>
</RCTLIN>

Here is the map:-

Outcomes