title: How to find unique values from set of rows using pentaho kettle?
body: <p>I have one de normalized table. I want to select all the values from one specific column of that table and load only unique values from that column into separate table. </p>
  
  <p>How to do this using Pentaho Spoon? Please note that I am totally newbie to Spoon. I have tried only hello world transformation in my life. </p>
  
  <p>I have table named 'Employees' which has lots of columns as follows (I have not given unrelated columns here):</p>
  
  <pre><code>+-------------------------------------------------------+
  
                             Employees
  +-------------------------------------------------------+
  
  employee_number | employee_name | deputed_branch | phone
  
  +-------------------------------------------------------+
  </code></pre>
  
  <p>Now I want to move only unique branch names into new table named <code>branches</code> using Spoon.</p>
  
  <p>'branches' table will look like following : </p>
  
  <pre><code>+-------------------------------------------------------+
  
                             branches
  +-------------------------------------------------------+
  
  | branch_id | branch_name 
  
  +-------------------------------------------------------+
  </code></pre>
  
  <p>where branch_id will be unique and auto incremented.</p>
  
  <p>To connect <code>Employees</code> and <code>branches</code> table I will use <code>Employee_branch</code> table which will consist of <code>employee_number</code> and <code>branch_id</code> column.</p>
  
  <p>Can anyone please tell how to do this? </p>
  
  <p>Thanks in advance !!</p>