Icon

Exercise 1

Exercise 1: Read Data From File and Insert Into Database1. Read Data From File2. Create Table In Database3. Manipulate Data and Insert Into Database Step 1: Read Data From File1. Read demographic.xlsxusing Excel Reader Step 2: Create Table In Database1. Connect to Database using PostgreSQL Connector2. Create demographic table inside database using DB Table Creator3. View created table using DB Table Selector Step 3: Manipulate Data and Insert Into Database1. Convert ID Column in Dataset From Integer to String2. Rename Column name in Dataset Match with ColumnIn Database3. Rename Column Name In Database Match withColumn In Dataset4. Insert Data In Dataset Into Database5. Read Inserted Data in Database Database Detailsip: 107.155.65.148port: 5432db: jpmdbusername: jpmdbapassword: Fotia123!? Quiz 1: Read Data From File and Insert Into DatabaseInsert all Data in File travel_advisory.csv into Table named as advisory_[your name]. Column name in Database must follow Column name in File Dataset. Method 1 Method 2 Connect to PostgreSQLRead Filedemographic.xlsxInsert Data in DatasetInto DatabaseRename Column NameMatch with ColumnIn DatabaseConvert ID ColumnFrom Integer to StringSelect CreatedTableRename Column NameMatch with Columnin DatasetRead InsertedDataView Data inCreated TableRead Filetravel_advisory.csvConnect to PostgreSQLCreate advisory tablein DatabaseInsert Data in DatasetInto DatabaseRead Inserted DataConnect to PostgreSQLCreate advisory tablein DatabaseRead Filetravel_advisory.csvInsert Data in DatasetInto DatabaseCreate demographic tablein Database PostgreSQLConnector Excel Reader DB Insert Table Manipulator Number To String DB Table Selector DB SQL Executor DB Reader DB Reader CSV Reader PostgreSQLConnector DB Table Creator DB Insert DB Reader PostgreSQLConnector DB Table Creator CSV Reader DB Insert DB Table Creator Exercise 1: Read Data From File and Insert Into Database1. Read Data From File2. Create Table In Database3. Manipulate Data and Insert Into Database Step 1: Read Data From File1. Read demographic.xlsxusing Excel Reader Step 2: Create Table In Database1. Connect to Database using PostgreSQL Connector2. Create demographic table inside database using DB Table Creator3. View created table using DB Table Selector Step 3: Manipulate Data and Insert Into Database1. Convert ID Column in Dataset From Integer to String2. Rename Column name in Dataset Match with ColumnIn Database3. Rename Column Name In Database Match withColumn In Dataset4. Insert Data In Dataset Into Database5. Read Inserted Data in Database Database Detailsip: 107.155.65.148port: 5432db: jpmdbusername: jpmdbapassword: Fotia123!? Quiz 1: Read Data From File and Insert Into DatabaseInsert all Data in File travel_advisory.csv into Table named as advisory_[your name]. Column name in Database must follow Column name in File Dataset. Method 1 Method 2 Connect to PostgreSQLRead Filedemographic.xlsxInsert Data in DatasetInto DatabaseRename Column NameMatch with ColumnIn DatabaseConvert ID ColumnFrom Integer to StringSelect CreatedTableRename Column NameMatch with Columnin DatasetRead InsertedDataView Data inCreated TableRead Filetravel_advisory.csvConnect to PostgreSQLCreate advisory tablein DatabaseInsert Data in DatasetInto DatabaseRead Inserted DataConnect to PostgreSQLCreate advisory tablein DatabaseRead Filetravel_advisory.csvInsert Data in DatasetInto DatabaseCreate demographic tablein DatabasePostgreSQLConnector Excel Reader DB Insert Table Manipulator Number To String DB Table Selector DB SQL Executor DB Reader DB Reader CSV Reader PostgreSQLConnector DB Table Creator DB Insert DB Reader PostgreSQLConnector DB Table Creator CSV Reader DB Insert DB Table Creator

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: zaki
Created at: 2023-07-31
On NodePit since: 2023-08-02
Last update: 2024-09-20
Created with KNIME version: v4.4.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!