Search code examples
sqlpentahokettle

Pentaho Join table values

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.

I've got 2 files, that i export from my DB:

File 1:

Row1, Row2
 A      3
 B      5
 C      99
 Z      65

File 2: 

Row1, Row2
 A      3
 D      11
 E      22
 Z      65

And i want to create one file output:

File Output

Row1, Row2
 A      3
 Z      65

What i'm doing: 2 files input, merge join, but no file output. Something missing here.

Any suggestion will be great!!!

Solution

  • You can have the two streams joined by a "Merge join" step, which allows you to set freely the join keys (in your case it seems like you want both fields to be used), and also what type of join, Inner, Left Outer, Right outer or Full outer.