I want to update a new database's table based on an old one
this is the data in the old table:
id,type 1,bla 2,bla bla
the new table is empty. Currently i have the two input table steps connected to a merge rows diff step and then funnel that into a sync after merge step.
the issue is that I get the flagfield set to deleted 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:
not found in compare stream --> set flag to needs insert --> insert in compare table ??
How do I do this?
