title: XML CHild node iteration in Pentaho
body: <p>I have an <strong>XML</strong> file which has data in format:</p>
  
  <pre><code>&lt;LineHeader&gt;
    &lt;LineItem LineNumber="1"&gt;
      &lt;Product SKU="99991L" DespatchQuantity="70"&gt;
        &lt;Item Type="EANCode"&gt;0821793005795&lt;/Item&gt;
        &lt;SKUDescription1&gt;HTC SNAP SYST&lt;/SKUDescription1&gt;
        &lt;SKUDescription2 /&gt;
        &lt;SerialNumberHeader&gt;
          &lt;SerialNumber&gt;358991022404733&lt;/SerialNumber&gt;
          &lt;SerialNumber&gt;358991022404808&lt;/SerialNumber&gt;
        &lt;/SerialNumberHeader&gt;
      &lt;/Product&gt;
    &lt;/LineItem&gt;
    &lt;LineItem LineNumber="2"&gt;
      &lt;Product SKU="37099M" DespatchQuantity="50"&gt;
        &lt;Item Type="EANCode"&gt;0843163067660&lt;/Item&gt;
        &lt;SKUDescription1&gt;RIM KEPLER SYST&lt;/SKUDescription1&gt;
        &lt;SKUDescription2 /&gt;
        &lt;SerialNumberHeader&gt;
          &lt;SerialNumber&gt;353933040011632&lt;/SerialNumber&gt;
          &lt;SerialNumber&gt;353933042759923&lt;/SerialNumber&gt;
        &lt;/SerialNumberHeader&gt;
      &lt;/Product&gt;
    &lt;/LineItem&gt;
  &lt;/LineHeader&gt;
  </code></pre>
  
  <p>Now I want output to be a text file with column names and records like these:</p>
  
  <pre><code>LineItem 
  LineNumber  Product SKU EANCode         SKUDescription1   SerialNumber
  1           99991L      821793005795    HTC SNAP SYST     358991022404808
  1           99991L      821793005795    HTC SNAP SYST     358991022434987
  1           99991L      821793005795    HTC SNAP SYST     358991022435505
  2           37099M      843163067660    RIM KEPLER SYST   353933040011632
  2           37099M      843163067660    RIM KEPLER SYST   353933042759923
  </code></pre>
  
  <p>Output data should look like the above table. 
  How can we achieve the looping in <strong>pentaho</strong>.</p>