Controlling data flow in XML processing

Question

We use XSLT to map business data from XML to XML and with no web involvement. I need to take XML input and output the same data with certain types of multiply occurring records consolidated into one. What is simple in procedural language has me stumped with XSLT.

I need to process this XML to output this same data with some records aggragated into a single record.

Each G07 represents an E2EDT37 carton and each E2EDT43 below the E2EDT37 is a part and quantity within that carton. The fields that identify the part are E2EDT43_VBELN and E2EDT43_POSNR.

The last G07 has 2 E2EDT42 records that represent the same part with E2EDT43_VBELN=0060088483 and E2EDT43_POSNR=000010. We shipped 178 but get 2 E2EDT43s with quantities of 1 and 177 instead of 1 E2EDT43 with 178.

So I need a template that will go through and create identical output to the input aside from combining the relevant E2EDT43s.

This is the input:

<G07>
  <E2EDT37>
      <E2EDT37_SEGNAM>E2EDT37006</E2EDT37_SEGNAM>
  </E2EDT37>
  <E2EDT38>
    <E2EDT38_SEGNAM>E2EDT38000</E2EDT38_SEGNAM>
  </E2EDT38>
  <E2EDT43>
    <E2EDT43_SEGNAM>E2EDT43005</E2EDT43_SEGNAM>
    <E2EDT43_VELIN>1</E2EDT43_VELIN>
    <E2EDT43_VBELN>0060085134</E2EDT43_VBELN>
    <E2EDT43_POSNR>000010</E2EDT43_POSNR>
    <E2EDT43_VEMNG>80.000</E2EDT43_VEMNG>
    <E2EDT43_VEMEH>PCE</E2EDT43_VEMEH>
    <E2EDT43_MATNR>089627903000005</E2EDT43_MATNR>
  </E2EDT43>
</G07>
<G07>
  <E2EDT37>
    <E2EDT37_SEGNAM>E2EDT37006</E2EDT37_SEGNAM>
  </E2EDT37>
  <E2EDT38>
    <E2EDT38_SEGNAM>E2EDT38000</E2EDT38_SEGNAM>
  </E2EDT38>
  <E2EDT43>
    <E2EDT43_SEGNAM>E2EDT43005</E2EDT43_SEGNAM>
    <E2EDT43_VELIN>1</E2EDT43_VELIN>
    <E2EDT43_VBELN>0060085134</E2EDT43_VBELN>
    <E2EDT43_POSNR>000010</E2EDT43_POSNR>
    <E2EDT43_VEMNG>80.000</E2EDT43_VEMNG>
    <E2EDT43_VEMEH>PCE</E2EDT43_VEMEH>
    <E2EDT43_MATNR>089627903000005</E2EDT43_MATNR>
  </E2EDT43>
</G07>
<G07>
  <E2EDT37>
    <E2EDT37_SEGNAM>E2EDT37006</E2EDT37_SEGNAM>
  </E2EDT37>
  <E2EDT38>
    <E2EDT38_SEGNAM>E2EDT38000</E2EDT38_SEGNAM>
  </E2EDT38>
  <E2EDT43>
    <E2EDT43_SEGNAM>E2EDT43005</E2EDT43_SEGNAM>
    <E2EDT43_VELIN>1</E2EDT43_VELIN>
    <E2EDT43_VBELN>0060088483</E2EDT43_VBELN>
    <E2EDT43_POSNR>000010</E2EDT43_POSNR>
    <E2EDT43_VEMNG>1.000</E2EDT43_VEMNG>
    <E2EDT43_VEMEH>PCE</E2EDT43_VEMEH>
    <E2EDT43_MATNR>089136322000005</E2EDT43_MATNR>
  </E2EDT43>
  <E2EDT43>
    <E2EDT43_SEGNAM>E2EDT43005</E2EDT43_SEGNAM>
    <E2EDT43_VELIN>1</E2EDT43_VELIN>
    <E2EDT43_VBELN>0060088483</E2EDT43_VBELN>
    <E2EDT43_POSNR>000010</E2EDT43_POSNR>
    <E2EDT43_VEMNG>177.000</E2EDT43_VEMNG>
    <E2EDT43_VEMEH>PCE</E2EDT43_VEMEH>
    <E2EDT43_MATNR>089136322000005</E2EDT43_MATNR>
  </E2EDT43>
</G07>   </G01> </ACTIS>

This above needs to become this:

<G07>
  <E2EDT37>
      <E2EDT37_SEGNAM>E2EDT37006</E2EDT37_SEGNAM>
  </E2EDT37>
  <E2EDT38>
    <E2EDT38_SEGNAM>E2EDT38000</E2EDT38_SEGNAM>
  </E2EDT38>
  <E2EDT43>
    <E2EDT43_SEGNAM>E2EDT43005</E2EDT43_SEGNAM>
    <E2EDT43_VELIN>1</E2EDT43_VELIN>
    <E2EDT43_VBELN>0060085134</E2EDT43_VBELN>
    <E2EDT43_POSNR>000010</E2EDT43_POSNR>
    <E2EDT43_VEMNG>80.000</E2EDT43_VEMNG>
    <E2EDT43_VEMEH>PCE</E2EDT43_VEMEH>
    <E2EDT43_MATNR>089627903000005</E2EDT43_MATNR>
  </E2EDT43>
</G07>
<G07>
  <E2EDT37>
    <E2EDT37_SEGNAM>E2EDT37006</E2EDT37_SEGNAM>
  </E2EDT37>
  <E2EDT38>
    <E2EDT38_SEGNAM>E2EDT38000</E2EDT38_SEGNAM>
  </E2EDT38>
  <E2EDT43>
    <E2EDT43_SEGNAM>E2EDT43005</E2EDT43_SEGNAM>
    <E2EDT43_VELIN>1</E2EDT43_VELIN>
    <E2EDT43_VBELN>0060085134</E2EDT43_VBELN>
    <E2EDT43_POSNR>000010</E2EDT43_POSNR>
    <E2EDT43_VEMNG>80.000</E2EDT43_VEMNG>
    <E2EDT43_VEMEH>PCE</E2EDT43_VEMEH>
    <E2EDT43_MATNR>089627903000005</E2EDT43_MATNR>
  </E2EDT43>
</G07>
<G07>
  <E2EDT37>
    <E2EDT37_SEGNAM>E2EDT37006</E2EDT37_SEGNAM>
  </E2EDT37>
  <E2EDT38>
    <E2EDT38_SEGNAM>E2EDT38000</E2EDT38_SEGNAM>
  </E2EDT38>
  <E2EDT43>
    <E2EDT43_SEGNAM>E2EDT43005</E2EDT43_SEGNAM>
    <E2EDT43_VELIN>1</E2EDT43_VELIN>
    <E2EDT43_VBELN>0060088483</E2EDT43_VBELN>
    <E2EDT43_POSNR>000010</E2EDT43_POSNR>
    <E2EDT43_VEMNG>178.000</E2EDT43_VEMNG>
    <E2EDT43_VEMEH>PCE</E2EDT43_VEMEH>
    <E2EDT43_MATNR>089136322000005</E2EDT43_MATNR>
  </E2EDT43>
</G07>   </G01> </ACTIS>

I did have a template that would go through and add elements to certain record types and it workled well. But I was matching on the E2EDT37 record and here I am matching at the G07 which has child records. What I can't grasp is how I would work on the G07 data and combine the like E2EDT43s, write out the new G07 and then resume processing the data after the end of the G07? I lose context and don't know how to resume at the next G07 or whatever record comes next. The data has been simplified here to just the relevant records, but there is much more data after the G07 groups that doesn't need any changes.

This is what was working to add elements to certain records and otherwise repreoduce the input exactly. When the E2EDT37 or E2EDT43 template executed the flow just continued to the next record but matching on the G07 and processing the node with children I can't manage to so that.

<xsl:template match="*" name="segments">

    <xsl:choose>
        <xsl:when test="name() = 'E2EDT37' ">
            <xsl:call-template name="E2EDT37">
                <xsl:with-param name="E2EDT37" select="."/>
            </xsl:call-template>
        </xsl:when>
        <xsl:when test="name() = 'E2EDT43' ">
            <xsl:call-template name="E2EDT43">
                <xsl:with-param name="E2EDT43" select="."/>
            </xsl:call-template>
        </xsl:when>
        <xsl:when test="name(child::*[1]) != ''">
            <xsl:element name="{name()}">
                <!-- write parent segment -->
                <xsl:for-each select="child::*">
                    <!-- read child segment -->
                    <xsl:call-template name="segments"/>
                </xsl:for-each>
            </xsl:element>
        </xsl:when>
        <xsl:otherwise>
            <xsl:choose>
                <xsl:when test=".!='' and name()!='rest'">
                    <xsl:call-template name="create_element"/>
                </xsl:when>
            </xsl:choose>
        </xsl:otherwise>
    </xsl:choose>
</xsl:template>

Answer 1

Use the following Powershell Script. You need to use the parent node to get data. I create a parent node Root to get results

Here is XML file

<Root>
    <E2EDT20_SEGNAM>E2EDT20002</E2EDT20_SEGNAM>
    <E2EDT20_MANDT>100</E2EDT20_MANDT>
    <E2EDT20_DOCNUM>0000008142818069</E2EDT20_DOCNUM>
    <E2EDT20_SEGNUM>000001</E2EDT20_SEGNUM>
    <E2EDT20_PSGNUM>000000</E2EDT20_PSGNUM>
    <E2EDT20_HLEVEL>01</E2EDT20_HLEVEL>
    <E2EDT20_TKNUM>1200447887</E2EDT20_TKNUM>
    <E2EDT20_SHTYP>Y008</E2EDT20_SHTYP>
    <E2EDT37_SEGNAM>E2EDT37006</E2EDT37_SEGNAM>
    <E2EDT37_MANDT>100</E2EDT37_MANDT>
    <E2EDT37_DOCNUM>0000008142818069</E2EDT37_DOCNUM>
    <E2EDT37_SEGNUM>000020</E2EDT37_SEGNUM>
    <E2EDT37_PSGNUM>000001</E2EDT37_PSGNUM>
    <E2EDT37_EXIDV>00340051082800455472</E2EDT37_EXIDV>
    <E2EDT37_VHILM>0845550170000 #E</E2EDT37_VHILM>
    <E2EDT37_VEBEZ>EWM-VERSANDPALETTE 20KG-9990088889</E2EDT37_VEBEZ>
    <E2EDT37_SMGKN>S</E2EDT37_SMGKN>
    <E2EDT38_SEGNAM>E2EDT38000</E2EDT38_SEGNAM>
    <E2EDT38_MANDT>100</E2EDT38_MANDT>
    <E2EDT38_DOCNUM>0000008142818069</E2EDT38_DOCNUM>
    <E2EDT38_SEGNUM>000021</E2EDT38_SEGNUM>
    <E2EDT38_PSGNUM>000020</E2EDT38_PSGNUM>
    <E2EDT38_HLEVEL>03</E2EDT38_HLEVEL>
    <E2EDT38_VHART_BEZ>expendable packaging</E2EDT38_VHART_BEZ>
    <E2EDT38_VEBEZ>EWM-VERSANDPALETTE 20KG-9990088889</E2EDT38_VEBEZ>
    <E2EDT43_SEGNAM>E2EDT43005</E2EDT43_SEGNAM>
    <E2EDT43_MANDT>100</E2EDT43_MANDT>
    <E2EDT43_DOCNUM>0000008142818069</E2EDT43_DOCNUM>
    <E2EDT43_SEGNUM>000022</E2EDT43_SEGNUM>
    <E2EDT43_PSGNUM>000020</E2EDT43_PSGNUM>
    <E2EDT43_VELIN>1</E2EDT43_VELIN>
    <E2EDT43_VBELN>0060085134</E2EDT43_VBELN>
    <E2EDT43_POSNR>000010</E2EDT43_POSNR>
    <E2EDT43_VEMNG>80.000</E2EDT43_VEMNG>
    <E2EDT43_VEMEH>PCE</E2EDT43_VEMEH>
    <E2EDT43_MATNR>089627903000005</E2EDT43_MATNR>
    <E2EDT43_CHARG>AAM0000000</E2EDT43_CHARG>
    <E2EDT37_SEGNAM>E2EDT37006</E2EDT37_SEGNAM>
    <E2EDT37_MANDT>100</E2EDT37_MANDT>
    <E2EDT37_DOCNUM>0000008142818069</E2EDT37_DOCNUM>
    <E2EDT37_SEGNUM>000023</E2EDT37_SEGNUM>
    <E2EDT37_PSGNUM>000001</E2EDT37_PSGNUM>
    <E2EDT37_EXIDV>00340051082800455496</E2EDT37_EXIDV>
    <E2EDT37_VHILM>0845550170000 #E</E2EDT37_VHILM>
    <E2EDT37_VEBEZ>EWM-VERSANDPALETTE 20KG-9990088889</E2EDT37_VEBEZ>
    <E2EDT37_SMGKN>S</E2EDT37_SMGKN>
    <E2EDT38_SEGNAM>E2EDT38000</E2EDT38_SEGNAM>
    <E2EDT38_MANDT>100</E2EDT38_MANDT>
    <E2EDT38_DOCNUM>0000008142818069</E2EDT38_DOCNUM>
    <E2EDT38_SEGNUM>000024</E2EDT38_SEGNUM>
    <E2EDT38_PSGNUM>000023</E2EDT38_PSGNUM>
    <E2EDT38_HLEVEL>03</E2EDT38_HLEVEL>
    <E2EDT38_VHART_BEZ>expendable packaging</E2EDT38_VHART_BEZ>
    <E2EDT38_VEBEZ>EWM-VERSANDPALETTE 20KG-9990088889</E2EDT38_VEBEZ>
    <E2EDT43_SEGNAM>E2EDT43005</E2EDT43_SEGNAM>
    <E2EDT43_MANDT>100</E2EDT43_MANDT>
    <E2EDT43_DOCNUM>0000008142818069</E2EDT43_DOCNUM>
    <E2EDT43_SEGNUM>000025</E2EDT43_SEGNUM>
    <E2EDT43_PSGNUM>000023</E2EDT43_PSGNUM>
    <E2EDT43_HLEVEL>03</E2EDT43_HLEVEL>
    <E2EDT43_VELIN>1</E2EDT43_VELIN>
    <E2EDT43_VBELN>0060085134</E2EDT43_VBELN>
    <E2EDT43_POSNR>000010</E2EDT43_POSNR>
    <E2EDT43_VEMNG>80.000</E2EDT43_VEMNG>
    <E2EDT43_VEMEH>PCE</E2EDT43_VEMEH>
    <E2EDT43_MATNR>089627903000005</E2EDT43_MATNR>
    <E2EDT43_CHARG>AAM0000000</E2EDT43_CHARG>
    <E2EDT37_SEGNAM>E2EDT37006</E2EDT37_SEGNAM>
    <E2EDT37_MANDT>100</E2EDT37_MANDT>
    <E2EDT37_DOCNUM>0000008142818069</E2EDT37_DOCNUM>
    <E2EDT37_SEGNUM>000026</E2EDT37_SEGNUM>
    <E2EDT37_PSGNUM>000001</E2EDT37_PSGNUM>
    <E2EDT37_EXIDV>00340051082800455625</E2EDT37_EXIDV>
    <E2EDT37_VHILM>0845550170000 #E</E2EDT37_VHILM>
    <E2EDT37_VEBEZ>EWM-VERSANDPALETTE 20KG-9990088889</E2EDT37_VEBEZ>
    <E2EDT37_SMGKN>S</E2EDT37_SMGKN>
    <E2EDT38_SEGNAM>E2EDT38000</E2EDT38_SEGNAM>
    <E2EDT38_MANDT>100</E2EDT38_MANDT>
    <E2EDT38_DOCNUM>0000008142818069</E2EDT38_DOCNUM>
    <E2EDT38_SEGNUM>000027</E2EDT38_SEGNUM>
    <E2EDT38_PSGNUM>000026</E2EDT38_PSGNUM>
    <E2EDT38_HLEVEL>03</E2EDT38_HLEVEL>
    <E2EDT38_VHART_BEZ>expendable packaging</E2EDT38_VHART_BEZ>
    <E2EDT38_VEBEZ>EWM-VERSANDPALETTE 20KG-9990088889</E2EDT38_VEBEZ>
    <E2EDT43_SEGNAM>E2EDT43005</E2EDT43_SEGNAM>
    <E2EDT43_MANDT>100</E2EDT43_MANDT>
    <E2EDT43_DOCNUM>0000008142818069</E2EDT43_DOCNUM>
    <E2EDT43_SEGNUM>000028</E2EDT43_SEGNUM>
    <E2EDT43_PSGNUM>000026</E2EDT43_PSGNUM>
    <E2EDT43_HLEVEL>03</E2EDT43_HLEVEL>
    <E2EDT43_VELIN>1</E2EDT43_VELIN>
    <E2EDT43_VBELN>0060088483</E2EDT43_VBELN>
    <E2EDT43_POSNR>000010</E2EDT43_POSNR>
    <E2EDT43_VEMNG>1.000</E2EDT43_VEMNG>
    <E2EDT43_VEMEH>PCE</E2EDT43_VEMEH>
    <E2EDT43_MATNR>089136322000005</E2EDT43_MATNR>
    <E2EDT43_CHARG>AAM0000000</E2EDT43_CHARG>
    <E2EDT43_SEGNAM>E2EDT43005</E2EDT43_SEGNAM>
    <E2EDT43_MANDT>100</E2EDT43_MANDT>
    <E2EDT43_DOCNUM>0000008142818069</E2EDT43_DOCNUM>
    <E2EDT43_SEGNUM>000029</E2EDT43_SEGNUM>
    <E2EDT43_PSGNUM>000026</E2EDT43_PSGNUM>
    <E2EDT43_HLEVEL>03</E2EDT43_HLEVEL>
    <E2EDT43_VELIN>1</E2EDT43_VELIN>
    <E2EDT43_VBELN>0060088483</E2EDT43_VBELN>
    <E2EDT43_POSNR>000010</E2EDT43_POSNR>
    <E2EDT43_VEMNG>177.000</E2EDT43_VEMNG>
    <E2EDT43_VEMEH>PCE</E2EDT43_VEMEH>
    <E2EDT43_MATNR>089136322000005</E2EDT43_MATNR>
    <E2EDT43_CHARG>AAM0000000</E2EDT43_CHARG>
</Root>

Here is Powershell script

using assembly System.Xml.Linq

$inputFilename = 'c:\temp\test.xml'
$outputFilename = 'c:\temp\test1.xml'

$doc = [System.Xml.Linq.XDocument]::Load($inputFilename)

$root = $doc.Descendants('Root')[0]
$elements = $root.Elements();

$groups = [System.Linq.Enumerable]::GroupBy($elements,  [Func[object,object]]{ param($x) $x[0].Name.LocalName})


$distinct = [Linq.Enumerable]::Select($groups, [Func[object,object]] { param($x) $x[0] })

$z = $null
$distinct = [Linq.Enumerable]::Select($groups, [Func[object,object]] { 
   param($x) if([Linq.Enumerable]::All($x, [Func[object,bool]]{ param($y) [double]::TryParse($y.Value, [ref]$z)})) { 
         [pscustomobject]@{
            element = @($x)[0]
            sum = [Linq.Enumerable]::Sum($x, [Func[object,double]]{ param($y) [double]::Parse($y.Value)})
            }
         } else {[pscustomobject]@{
            element = @($x)[0]
            sum = $null
            }
         } 
       })

$orderNodes = [Linq.Enumerable]::OrderBy($distinct, [Func[object,object]] { param($x) $x[0].element.Name.LocalName })

$root.RemoveNodes()
foreach($node in $orderNodes)
{
   $element = $node.element
   if($node.sum -ne $null) { $element.SetValue($node.sum) }
   $root.Add($element)
}
$doc.Save($outputFilename)

Here is results

<?xml version="1.0" encoding="utf-8"?>
<Root>
  <E2EDT20_DOCNUM>8142818069</E2EDT20_DOCNUM>
  <E2EDT20_HLEVEL>1</E2EDT20_HLEVEL>
  <E2EDT20_MANDT>100</E2EDT20_MANDT>
  <E2EDT20_PSGNUM>0</E2EDT20_PSGNUM>
  <E2EDT20_SEGNAM>E2EDT20002</E2EDT20_SEGNAM>
  <E2EDT20_SEGNUM>1</E2EDT20_SEGNUM>
  <E2EDT20_SHTYP>Y008</E2EDT20_SHTYP>
  <E2EDT20_TKNUM>1200447887</E2EDT20_TKNUM>
  <E2EDT37_DOCNUM>24428454207</E2EDT37_DOCNUM>
  <E2EDT37_EXIDV>1.0201532484013665E+18</E2EDT37_EXIDV>
  <E2EDT37_MANDT>300</E2EDT37_MANDT>
  <E2EDT37_PSGNUM>3</E2EDT37_PSGNUM>
  <E2EDT37_SEGNAM>E2EDT37006</E2EDT37_SEGNAM>
  <E2EDT37_SEGNUM>69</E2EDT37_SEGNUM>
  <E2EDT37_SMGKN>S</E2EDT37_SMGKN>
  <E2EDT37_VEBEZ>EWM-VERSANDPALETTE 20KG-9990088889</E2EDT37_VEBEZ>
  <E2EDT37_VHILM>0845550170000 #E</E2EDT37_VHILM>
  <E2EDT38_DOCNUM>24428454207</E2EDT38_DOCNUM>
  <E2EDT38_HLEVEL>9</E2EDT38_HLEVEL>
  <E2EDT38_MANDT>300</E2EDT38_MANDT>
  <E2EDT38_PSGNUM>69</E2EDT38_PSGNUM>
  <E2EDT38_SEGNAM>E2EDT38000</E2EDT38_SEGNAM>
  <E2EDT38_SEGNUM>72</E2EDT38_SEGNUM>
  <E2EDT38_VEBEZ>EWM-VERSANDPALETTE 20KG-9990088889</E2EDT38_VEBEZ>
  <E2EDT38_VHART_BEZ>expendable packaging</E2EDT38_VHART_BEZ>
  <E2EDT43_CHARG>AAM0000000</E2EDT43_CHARG>
  <E2EDT43_DOCNUM>32571272276</E2EDT43_DOCNUM>
  <E2EDT43_HLEVEL>9</E2EDT43_HLEVEL>
  <E2EDT43_MANDT>400</E2EDT43_MANDT>
  <E2EDT43_MATNR>357528450000020</E2EDT43_MATNR>
  <E2EDT43_POSNR>40</E2EDT43_POSNR>
  <E2EDT43_PSGNUM>95</E2EDT43_PSGNUM>
  <E2EDT43_SEGNAM>E2EDT43005</E2EDT43_SEGNAM>
  <E2EDT43_SEGNUM>104</E2EDT43_SEGNUM>
  <E2EDT43_VBELN>240347234</E2EDT43_VBELN>
  <E2EDT43_VELIN>4</E2EDT43_VELIN>
  <E2EDT43_VEMEH>PCE</E2EDT43_VEMEH>
  <E2EDT43_VEMNG>338</E2EDT43_VEMNG>
</Root>

Answer 2

Maybe this simple example will help you.

Input:

<root>
    <carton>
        <stuff/>
        <part>
            <id1>a</id1>
            <id2>b</id2>
            <quantity>80.000</quantity>
        </part>
        <part>
            <id1>a</id1>
            <id2>c</id2>
            <quantity>100.000</quantity>
        </part>
    </carton>
    <carton>
        <stuff/>
         <part>
            <id1>c</id1>
            <id2>d</id2>
            <quantity>80.000</quantity>
        </part>
    </carton>
    <carton>
        <stuff/>
        <part>
            <id1>e</id1>
            <id2>f</id2>
            <quantity>1.000</quantity>
        </part>
        <part>
            <id1>e</id1>
            <id2>f</id2>
            <quantity>177.000</quantity>
        </part>
    </carton>
</root>

Stylesheet (using XSLT 2.0):

<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes"/>

<!-- copy everything as is -->
<xsl:template match="@*|node()">
    <xsl:copy>
        <xsl:apply-templates select="@*|node()"/>
    </xsl:copy>
</xsl:template>

<!-- except: -->
<xsl:template match="carton">
    <xsl:copy>
        <xsl:copy-of select="* except part"/>
        <xsl:for-each-group select="part" group-by="concat(id1, '|', id2)">
            <xsl:copy>
                <xsl:copy-of select="* except quantity"/>
                <quantity>
                    <xsl:value-of select="sum(current-group()/quantity)"/> 
                </quantity>
            </xsl:copy>
        </xsl:for-each-group>
    </xsl:copy>                   
</xsl:template>

</xsl:stylesheet>

Output:

<?xml version="1.0" encoding="UTF-8"?>
<root>
   <carton>
      <stuff/>
      <part>
         <id1>a</id1>
         <id2>b</id2>
         <quantity>80</quantity>
      </part>
      <part>
         <id1>a</id1>
         <id2>c</id2>
         <quantity>100</quantity>
      </part>
   </carton>
   <carton>
      <stuff/>
      <part>
         <id1>c</id1>
         <id2>d</id2>
         <quantity>80</quantity>
      </part>
   </carton>
   <carton>
      <stuff/>
      <part>
         <id1>e</id1>
         <id2>f</id2>
         <quantity>178</quantity>
      </part>
   </carton>
</root>