Merges (insert/updates) all data rows from the
selected database table that match the values of a row from the selected KNIME input table columns.
All selected column names of the KNIME table need to exactly match the column names from the database.
The WHERE column values of the input KNIME data row need to match the values of the database row
to update; whereas the SET database column values are replaced by the input KNIME column values.
Only the rows matching all values of the selected column of any given input row will be updated.
If no matching rows are found, the node inserts new row into the selected database table.
The column order of the KNIME table and the database table do not need to match.
The output table contains two additional columns if Append merge statuses checkbox is checked. The first
extra columns is the number of rows affected by the MERGE statement. A number greater than or equal to
zero -- indicates that the command was processed successfully and is an update count giving the number of
rows in the database that were affected by the command's execution. A value of -2 -- indicates that the
command was processed successfully but that the number of rows affected is unknown. The second column
shows a warning message, if any.
Options
Settings
Output Type Mapping
This tab allows you to define rules to map from KNIME types to database types.
Popular Predecessors
Column Rename4 %- Excel Reader3 %
- DB Table Creator3 %
- Microsoft SQL Server Connector3 %
- Column Renamer3 %
- Table Manipulator2 %
- Missing Value2 %
- DB Reader2 %
- DB SQL Executor2 %
- Column Filter2 %
- Joiner2 %
- DB Query Reader2 %
- String Manipulation2 %
- DB Merge2 %
- Rule Engine2 %
- DB Writer2 %
- PostgreSQL Connector2 %
Row Filter (deprecated)1 %- Column Expressions1 %
Table Row to Variable1 %Column Appender1 %- Constant Value Column1 %
- DB Connector1 %
- DB Delete (Table)1 %
- String to Date&Time1 %
- Table Creator1 %
- Row Filter (Labs)1 %
- MySQL Connector< 1 %
Excel Reader (XLS)< 1 %- IF Switch< 1 %
- DB Delete (Filter)< 1 %
- Column Resorter< 1 %
- Python Script (legacy)< 1 %
Row Splitter (deprecated)< 1 %- H2 Connector< 1 %
- Math Formula (Multi Column)< 1 %
- Variable to Table Column< 1 %
- Concatenate< 1 %
- Duplicate Row Filter< 1 %
- GroupBy< 1 %
- DB Insert< 1 %
- Parameterized DB Query Reader< 1 %
- Wait...< 1 %
- CSV Reader< 1 %
- DB Looping< 1 %
- Timer Info< 1 %
- String to Number< 1 %
- Table Validator (Reference)< 1 %
- DB Connection Extractor< 1 %
- Date&Time-based Row Filter< 1 %
- Linear Correlation< 1 %
- DB Query< 1 %
- Math Formula< 1 %
- Number to String< 1 %
- Reference Row Filter< 1 %
- Empty Table Switch< 1 %
- Table Editor (JavaScript)< 1 %
- Loop End< 1 %
- Pivot< 1 %
- DB Table Selector< 1 %
- JSON Path< 1 %
- Legacy Date&Time to Date&Time< 1 %
Loop End< 1 %String To Number< 1 %- SQLite Connector< 1 %
Variable to Table Column< 1 %- Java Snippet< 1 %
- Chunk Loop Start< 1 %
- Column Auto Type Cast< 1 %
- Column Merger< 1 %
- Cross Joiner< 1 %
- Double to Integer< 1 %
Joiner< 1 %- Sorter< 1 %
- String Replacer< 1 %
- Ungroup< 1 %
- Rule-based Row Filter< 1 %
- Cache< 1 %
- Microsoft Access Connector< 1 %
- Oracle Connector< 1 %
- DB Update< 1 %
- DB Transaction Start< 1 %
DB Table Creator< 1 %- Table View (JavaScript)< 1 %
- Date&Time to String< 1 %
- Modify Time< 1 %
- File Reader< 1 %
- Case Converter< 1 %
- Column Appender< 1 %
- Column Renamer (Dictionary)< 1 %
- String Manipulation (Multi Column)< 1 %
- Top k Row Filter< 1 %
- Send Email< 1 %
- DB Loader< 1 %
- Date&Time Shift< 1 %
- Try (Data Ports)< 1 %
- Add Empty Rows< 1 %
- Amazon Redshift Connector< 1 %
Excel Reader (XLS)< 1 %- Table Row to Variable< 1 %
- Table Transposer< 1 %
- Column Rename (Regex)< 1 %
- Data Generator< 1 %
Database Reader< 1 %- End IF< 1 %
- DB Transaction End< 1 %
- Table Reader< 1 %
- Numeric Row Splitter< 1 %
- Column Splitter< 1 %
- Unpivot< 1 %
Variable to Table Column< 1 %Cell Replacer< 1 %- Create Table Structure< 1 %
- Row Sampling< 1 %
Read Excel Sheet Names (XLS)< 1 %- JSON to Table< 1 %
- Python Source (legacy)< 1 %
File Reader< 1 %- Don't Save End (3 Ports)< 1 %
- Database List Foreign Keys (Legacy)< 1 %
- PDB Saver< 1 %
- Download (legacy)< 1 %
- URL to File Path (Variable)< 1 %
- Inject Variables (Data)< 1 %
CSV Reader< 1 %Database Connection Table Reader< 1 %Variable Loop End< 1 %- Cluster Assigner< 1 %
- Column Combiner< 1 %
- Category to Number< 1 %
- Nominal Value Row Filter< 1 %
- RowID< 1 %
- String Manipulation (Variable)< 1 %
CASE Switch Data (End)< 1 %CASE Switch Data (Start)< 1 %Merge Variables< 1 %- Save Workflow< 1 %
- Vertica Connector< 1 %
- Java IF (Table)< 1 %
- String Configuration< 1 %
- Table to JSON< 1 %
- XPath< 1 %
- Wait< 1 %
IF Switch (Flow Variable Value)< 1 %Database IF Switch< 1 %- Line Reader< 1 %
List Files< 1 %- Missing Value Column Filter< 1 %
- Table Difference Finder< 1 %
- Rule Engine Variable< 1 %
- Statistics< 1 %
CASE Switch Variable (Start)< 1 %- Merge Variables< 1 %
- Parallel Chunk Start< 1 %
- Google BigQuery Connector< 1 %
- Counter Generation< 1 %
- Random Matcher< 1 %
- IDF< 1 %
- List Files/Folders< 1 %
- String Input (legacy)< 1 %
- Date&Time to legacy Date&Time< 1 %
- Create Date&Time Range< 1 %
- Date&Time Part Extractor< 1 %
Views
- This node has no views
Workflows
2021_01_18_DB_MergeKNIME Forum- 2021_01_18_DB_Merge_reproducedKNIME Forum
- Aufgabe2KNIME Hub
- Aufgabe7KNIME Hub
- BausteineKNIME Hub
- Show all 21 workflows
Links
- database insert or updateby ipazin on 2018-10-26forum.knime.com/p/49137
- Data loading too slow. What will happen if I cancel the execution?by izaychik63 on 2021-10-26forum.knime.com/p/137909
- Concatenation (?): update existing rows and add new onesby izaychik63 on 2019-02-20forum.knime.com/p/54873
- Help for add only new rowsby izaychik63 on 2020-06-16forum.knime.com/p/94424
- DB2 Inserts from Hadoopby izaychik63 on 2020-05-10forum.knime.com/p/90587
- Show all 12 links
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.