DB Merge node

MS-SQL Server MERGE allows delete operations. Is it possible DB Merge to have additional configuration with choice, if use Insert, Update, Delete in any combination?

Hello izaychik63,
good question. I will open a ticket for this to investigate this further. For now you can create a temporary table with the values from the KNIME table to merge and then use the DB SQL Executor node to execute a MS-SQL Server Merge statement.


This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.