I'm new to Pentaho.
This is the transformation I'm trying to do:
Import Transactions and Merchant and merge these two tables using MERCH_KEY
However, this isn't working, see below:
This is table Transactions
:
And this is table Merchant
:
And this is the Merge join
:
This all seems good, but it's not working and I have no idea why. From the preview, I can see the two tables are being imported, so how can I merge them?