Icon

db writer query output

input dataall columnsto stringadd 'around col valuesINSERT INTO no databasecolumn valuesVALUESINSERT INTO tmp.test (id, price, quantity) VALUES ('1', 'to much', '3.33', '11', 'medium', '0.23','5', 'average', '6.0')Node 1342DB Writer DB Connector Table Creator ExtractColumn Header Column Aggregator Column Aggregator Number To String String Manipulation(Multi Column) String Manipulation Variable Creator GroupBy String Manipulation Column Appender Column Aggregator SQLite Connector input dataall columnsto stringadd 'around col valuesINSERT INTO no databasecolumn valuesVALUESINSERT INTO tmp.test (id, price, quantity) VALUES ('1', 'to much', '3.33', '11', 'medium', '0.23','5', 'average', '6.0')Node 1342DB Writer DB Connector Table Creator ExtractColumn Header Column Aggregator Column Aggregator Number To String String Manipulation(Multi Column) String Manipulation Variable Creator GroupBy String Manipulation Column Appender Column Aggregator SQLite Connector

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: hans
Created at: 2023-03-02
On NodePit since: 2023-03-02
Last update: 2024-04-27
Created with KNIME version: v4.7.0

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

Try NodePit Runner!