Icon

Conditional insert into a database table

Conditional insert into database table
inspired by this forum post: https://forum.knime.com/t/conditional-insert/7381 Have a look what DB table looks like Connect to SQLite (small data base within the WF)Read from table "cmpds", just to see what db table looks likeInsert the rows that are not in there yetdata that should go into the data base, but would be double entries (aka are there already) insert the data into the temporary tablemanually introducting 10 rows that don't exist in the DB yet (SJXXX25%)and modify existing entries (insert TEST at hit column) to check if they don't get overwrittenCreate a temporary table in the DBsee if the newly introduced rows are there see if existing rows are not overwritten SQLite Connector DB Query Reader DB SQL Executor CSV Reader DB Insert Table Editor DB Table Creator DB Query Reader DB Query Reader inspired by this forum post: https://forum.knime.com/t/conditional-insert/7381 Have a look what DB table looks like Connect to SQLite (small data base within the WF)Read from table "cmpds", just to see what db table looks likeInsert the rows that are not in there yetdata that should go into the data base, but would be double entries (aka are there already) insert the data into the temporary tablemanually introducting 10 rows that don't exist in the DB yet (SJXXX25%)and modify existing entries (insert TEST at hit column) to check if they don't get overwrittenCreate a temporary table in the DBsee if the newly introduced rows are there see if existing rows are not overwrittenSQLite Connector DB Query Reader DB SQL Executor CSV Reader DB Insert Table Editor DB Table Creator DB Query Reader DB Query Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: glandrum
Created at: 2015-02-07
On NodePit since: 2021-05-06
Last update: 2024-05-02
Created with KNIME version: v4.3.2
Tags: Life ScienceCheminformaticsdatabaseconditional

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!