DB Merge with no SET columns

KNIME Analytics Platform
1

Hi folks,

I’m trying to do an insert using the DB Merge node, but all the columns in my table are primary keys. It doesn’t seem to want to let me set it up without adding at least one column in the SET section, but all my columns need to be in the WHERE.

Are there any ways to allow this? Any suggested workarounds?

Thanks!

2

Isn’t it the other way round. The values you want to have should be the set while the question which rows to change are the where.

If you really just want to insert data there is this node:

In general: having all columns as primary keys sounds like an uncommon structure. Maybe you want consider the implications of that.

1 Like