Icon

Project 2nd part (to database)

Here by importing the same CSV file, we will put it into DataBase and read this file itself.DataBase will not accept "hypher-minus" symbol as column names, replace it with underscore "_".Created database in PostgreSQL 17. There are multiple ways to query data from database, I showed some of them below.At the end, I created some new data from given table and inserted into database itself. Node 1Node 2Node 3Node 4Node 5Node 6Node 7Node 8Node 9Node 10Node 11Node 12Node 13Node 14 CSV Reader Column Renamer Column Rename(Regex) PostgreSQLConnector DB Loader DB Query Reader DB Table Selector DB Reader DB GroupBy DB Reader Double to Integer Column Renamer DB Table Creator DB Loader Here by importing the same CSV file, we will put it into DataBase and read this file itself.DataBase will not accept "hypher-minus" symbol as column names, replace it with underscore "_".Created database in PostgreSQL 17. There are multiple ways to query data from database, I showed some of them below.At the end, I created some new data from given table and inserted into database itself. Node 1Node 2Node 3Node 4Node 5Node 6Node 7Node 8Node 9Node 10Node 11Node 12Node 13Node 14CSV Reader Column Renamer Column Rename(Regex) PostgreSQLConnector DB Loader DB Query Reader DB Table Selector DB Reader DB GroupBy DB Reader Double to Integer Column Renamer DB Table Creator DB Loader

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: seraf
Created at: 2024-10-07
On NodePit since: 2024-10-14
Last update: 2024-11-21
Created with KNIME version: v5.3.2

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

Try NodePit Runner!