Icon

kn_​example_​db_​h2_​merge

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

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


MERGE an existing database and insert new rows with H2 - use the Northwind DB current timestart_timeNorthwind_small.h2wait 10 secondssample to function as updatemerge bycustomeridunknown lines will beaddedtransfer 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 last_updated databse based oncustomeridfirst_insertedfirst_insertedfirst_insertedfirst_insertedENDstatus at the end of updatenew_customer_tableinitial status of the tableemptylast_updated Create Date&TimeRange H2 Connector Wait... Partitioning DB Merge 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 ConstantValue Column String to Date&Time DB ConnectionExtractor Variable Loop End DB Query Reader DB Query Reader DB SQL Executor DB ConnectionExtractor MERGE an existing database and insert new rows with H2 - use the Northwind DB current timestart_timeNorthwind_small.h2wait 10 secondssample to function as updatemerge bycustomeridunknown lines will beaddedtransfer 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 last_updated databse based oncustomeridfirst_insertedfirst_insertedfirst_insertedfirst_insertedENDstatus at the end of updatenew_customer_tableinitial status of the tableemptylast_updatedCreate Date&TimeRange H2 Connector Wait... Partitioning DB Merge 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 ConstantValue Column String to Date&Time DB ConnectionExtractor Variable Loop End DB Query Reader DB Query Reader DB SQL Executor DB ConnectionExtractor

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!