Icon

DB demo 20240120

Demonstrating table creation and in-database data insertion using SQL Executor

any required db deletion could go here, or add it manually in the DB SQL Executorstatement (as demonstrated) Local database(set to in memory, so lost each time this node is reset,but this makes it useful for demonstrations!get distinct list of entityand monthiterate ENTITY and monthselect rows for the given ENTITYgrab the select statementcreate table for entityif not existsexecute the in-databaseinsert statementselecting using the extractedselect statementtop and tail the list of columnsget the column namesbuild delimitedlist ofcolumn namesNode 30ENTUPDATEScreate sample dataENTUPDATESENTUPDATESNode 35repeatselect * from Atable structure H2 Connector DB Query Reader Table Row ToVariable Loop Start DB Table Selector DB Query Extractor DB Table Creator DB SQL Executor String Manipulation Extract Table Spec GroupBy Table Rowto Variable Table Creator DB Table Creator DB Insert DB Query Variable Loop End DB Query Reader DB To Empty Table any required db deletion could go here, or add it manually in the DB SQL Executorstatement (as demonstrated) Local database(set to in memory, so lost each time this node is reset,but this makes it useful for demonstrations!get distinct list of entityand monthiterate ENTITY and monthselect rows for the given ENTITYgrab the select statementcreate table for entityif not existsexecute the in-databaseinsert statementselecting using the extractedselect statementtop and tail the list of columnsget the column namesbuild delimitedlist ofcolumn namesNode 30ENTUPDATEScreate sample dataENTUPDATESENTUPDATESNode 35repeatselect * from Atable structureH2 Connector DB Query Reader Table Row ToVariable Loop Start DB Table Selector DB Query Extractor DB Table Creator DB SQL Executor String Manipulation Extract Table Spec GroupBy Table Rowto Variable Table Creator DB Table Creator DB Insert DB Query Variable Loop End DB Query Reader DB To Empty Table

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: bbate
Created at: 2023-10-31
On NodePit since: 2024-01-21
Last update: 2024-11-17
Created with KNIME version: v4.7.7

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

Try NodePit Runner!