Icon

kn_​example_​db_​h2_​insert_​and_​update

UPDATE an existing database and insert new rows with H2 - use the Northwind DB

UPDATE an existing database and insert new rows with H2 - use the Northwind DB


UPDATE an existing database and insert new rows with H2 - use the Northwind DB current timestart_timeNorthwind_small.h2wait 10 secondssample to function as updateall existing customerid afterthe updatetransfer to tablenew_customer_tableList allTablesremove H2 table"PUBLIC"."new_customer_table"create tbalenew_customer_tablecustomerid is a Primary Keycustomerstart_timelast_updatedlast_updatedsimulate new entriesSTART theloopupdate_timecurrent timeupdate_timesample to function as update=> here you would uploadnew datalast_updatedlast_updatedupdate the databse based oncustomeridfirst_insertedfirst_insertedexclude already existingcustomeridsfirst_insertedfirst_insertedinsert new customerids intothe tablenew_customer_tableENDstatus at the end of updatenew_customer_tableinitial status of the table Create Date&TimeRange H2 Connector Wait... Partitioning DB Reader DB Writer DB Query Reader DB SQL Executor DB Table Creator DB Query Reader Table Rowto Variable ConstantValue Column String to Date&Time Table Creator Table Row ToVariable Loop Start Table Rowto Variable Create Date&TimeRange Partitioning ConstantValue Column String to Date&Time DB Update ConstantValue Column String to Date&Time DB GroupBy ReferenceRow Filter ConstantValue Column String to Date&Time DB Writer DB ConnectionExtractor Variable Loop End DB Query Reader DB Query Reader UPDATE an existing database and insert new rows with H2 - use the Northwind DB current timestart_timeNorthwind_small.h2wait 10 secondssample to function as updateall existing customerid afterthe updatetransfer to tablenew_customer_tableList allTablesremove H2 table"PUBLIC"."new_customer_table"create tbalenew_customer_tablecustomerid is a Primary Keycustomerstart_timelast_updatedlast_updatedsimulate new entriesSTART theloopupdate_timecurrent timeupdate_timesample to function as update=> here you would uploadnew datalast_updatedlast_updatedupdate the databse based oncustomeridfirst_insertedfirst_insertedexclude already existingcustomeridsfirst_insertedfirst_insertedinsert new customerids intothe tablenew_customer_tableENDstatus at the end of updatenew_customer_tableinitial status of the tableCreate Date&TimeRange H2 Connector Wait... Partitioning DB Reader DB Writer DB Query Reader DB SQL Executor DB Table Creator DB Query Reader Table Rowto Variable ConstantValue Column String to Date&Time Table Creator Table Row ToVariable Loop Start Table Rowto Variable Create Date&TimeRange Partitioning ConstantValue Column String to Date&Time DB Update ConstantValue Column String to Date&Time DB GroupBy ReferenceRow Filter ConstantValue Column String to Date&Time DB Writer DB ConnectionExtractor Variable Loop End 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: m_lauber
Created at: 2021-12-29
On NodePit since: 2021-12-30
Last update: 2024-04-28
Created with KNIME version: v4.5.0
Tags: h2updateappenddatabseSQLNorthwind

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

Try NodePit Runner!