title: Pentaho Join table values
body: <p>I'm rookie at kettle pentaho and Querys. What i'm trying to do is check if value A, in file 1 is in file 2.</p>
  
  <p>I've got 2 files, that i export from my DB:</p>
  
  <p>File 1:</p>
  
  <pre><code>Row1, Row2
   A      3
   B      5
   C      99
   Z      65
  </code></pre>
  
  <p>File 2: </p>
  
  <pre><code>Row1, Row2
   A      3
   D      11
   E      22
   Z      65
  </code></pre>
  
  <p>And i want to create one file output:</p>
  
  <p>File Output</p>
  
  <pre><code>Row1, Row2
   A      3
   Z      65
  </code></pre>
  
  <p>What i'm doing: 2 files input, merge join, but no file output. Something missing here.</p>
  
  <p>Any suggestion will be great!!!</p>