title: How to split a CSV file into groups using Pentaho?
body: <p>I am new to Pentaho and am trying to read a CSV file (which I already did) and create blocks of data based on an identifier. </p>
  
  <blockquote>
    <p>Eg</p>
  </blockquote>
  
  <pre><code>1|A|B|C
  2|D|E|F
  8|G|H|I|J|K
  4|L|M
  1|N|O|P
  4|Q|R|S|T
  5|U|V|W
  </code></pre>
  
  <hr>
  
  <p>I need to split and group this as such:<br>
  <em>(each block starts when the first column is equal to '1')</em></p>
  
  <p><strong>Block a)</strong></p>
  
  <pre><code>1|A|B|C
  2|D|E|F
  8|G|H|I|J|K
  4|L|M
  </code></pre>
  
  <p><strong>Block b)</strong></p>
  
  <pre><code>1|N|O|P
  4|Q|R|S|T
  5|U|V|W
  </code></pre>
  
  <blockquote>
    <p>Eg</p>
  </blockquote>
  
  <pre><code> a |1|A|B|C
   a |2|D|E|F
   a |8|G|H|I|J|K
   a |4|L|M
  
   b |1|N|O|P
   b |4|Q|R|S|T
   b |5|U|V|W
  </code></pre>
  
  <p>How can this be achieved using Penatho? Thanks.</p>
  
  <p>I found a similar question but answers don't really help my case
  <a href="https://stackoverflow.com/questions/17710451/pentaho-kettle-split-csv-into-multiple-records">Pentaho Kettle split CSV into multiple records</a></p>