title: pentaho spoon/kettle merge row diff step
body: <p>I want to update a new database's table based on an old one</p>
  
  <p>this is the data in the old table:</p>
  
  <p>id,type
  1,bla
  2,bla bla</p>
  
  <p>the new table is empty. Currently i have the two <code>input table</code> steps connected to a <code>merge rows diff</code> step and then funnel that into a <code>sync after merge</code> step.</p>
  
  <p>the issue is that I get the flagfield set to <code>deleted</code> because it cannot find the any values in the compare stream (duh its an empty table!). Is my logic wrong or should it not work like this:</p>
  
  <p>not found in compare stream --> set flag to <code>needs insert</code> --> insert in compare table ??</p>
  
  <p>How do I do this?</p>