title: Pentaho - Can it handle manipulation of XML attributes?
body: <p>I'm looking at using Pentaho/Kettle for data ingestion.  I've already run into a problem, but I'm not sure if it's a problem with the tool or just lack of knowledge on my part.</p>
  
  <p>I've figured out how to create a transformation and read data from XML files, which is the first part of my transformation.  Unfortunately, my XML is somewhat like this:</p>
  
  <pre><code>&lt;rootnode&gt;
      &lt;category someattribute="cool" rownum="7"&gt;
          &lt;firstnode&gt;some data&lt;/firstnode&gt;
          &lt;secondnode&gt;more data&lt;/secondnode&gt;
      &lt;/category&gt;
      &lt;category someattribute="cooler" rownum="8"&gt;
          &lt;firstnode&gt;some data II&lt;/firstnode&gt;
          &lt;secondnode&gt;more data II&lt;/secondnode&gt;
      &lt;/category&gt;
  &lt;/rootnode&gt;
  </code></pre>
  
  <p>I was using the Input/Get data from XML step, and while I can get it to show all categories and firstnode/secondnode values properly, I can't find any way to even get a glimpse of the attributes rownum and someattribute.</p>
  
  <p>Is Kettle capable of processing XML attributes and allowing you to use them in transformation steps?  If so, how, or can someone show me to documentation on the subject? (I can't find any).</p>