Use Database Update Node to update the increased data in the database failed

KNIME Analytics Platform
1

Hi all,

My target is to using the Database Update node to update the table in the database, only update the increased data in the table. all the data has the unique ID. However, it seems the table in the database is till the old one.

my procedure as below:

  1. this is the old table
    1
  2. this is the updated table which add new record with the unique MID of 4
    2
  3. this the workflow I created and the configuration of database update node
    3
    4
    4754×668 58 KB
  4. this is the updated status of database update node
    5
  5. and this the table int he database after execution of database update, still the old one, the new data is not added
    6

I will highly apricate that someone can point out what’s wrong with my faults
Regards
Kevin

2

Update influence only existing records. To write new one you need to compare existing record set with new one. Filter new records (say with Reference Row Filter node) and use Database Writer to add new records.

3

Hi izaychik63,
thanks for your suggestions. It DO solve my challenge, seems there was some midunderstanding about the database update node.
Cheers,
Kevin