database insert or update

There is no such node. If the data does not exist, the data is inserted. If the data exists, the data is updated.

1 Like

Hi there!

Actually in new database integration nodes there is DB Merge node.

It is under KNIME Labs Extensions. As this is still in testing it is not intended for production.

Br,
Ivan

4 Likes

@ipazin, would this be considered safe in 1.1.2020?

Hi there @Tyler,

new database framework was out from Labs (production ready) with version 4.0:
https://www.knime.com/whats-new-in-knime-40#knime-database-extension

Any feedback is appreciated :wink:

Br,
Ivan

1 Like

Was going to ask a lot of questions until noticing the merge solution…

Wow, reading patch notes a second time, congrats on this update, slam dunk

1 Like