Database update Confuse

KNIME Analytics Platform
1

Hi all,

The challenge I met is as blow:

  1. My original table looks like as below
    1
  2. my targeted table to update is as below
    2
  3. I used Database update node to append the new added row, however, it always failed. It seems that the new added row cannot be update. the update node and result as below:
    4
    3
    3694×631 61.8 KB

    and the database output is still the same as updated before:
    6
    My confusion is that does Database update node cannot increase the new row, only update the existing row content?

Thanks for your support!
Regards,
Kevin

2

Hi Kevin!

I think Database Update node only updates existing rows so you can not use it in this case. What you need to use is Database Writer node to whom you need to provide only rows you do not have in you database.

In new 3.6 version there is a new database framework (not yet for production) which has DB Merge node which should do both insert and update:
(https://nodepit.com/node/org.knime.database.node.io.merge.DBMergeNodeFactory)

You can test it and let us know how it works :slight_smile:

Br,
Ivan

3

Hi Ivan,

Thanks for you reply. I will upgrade into 3.6 to try.
I will also try the Database Write 's append function . Still thanks for your instruction.

Regards,
Kevin

4

You are welcomed.
Ivan