Icon

Exercise 2

Exercise 2: Insert New Data Into Database (Exclude Duplicate Data)1. Read Data From Database2. Read Data From File3. Find and Remove Duplicate Data4. Insert New Data Into Database5. Read Updated Data In Database Step 1: Read Data From Database1. Connect to PostgreSQL2. Select demographic_[your name] table3. Read Data from Selected Table Step 2: Read Data From File1. Read Data form demographic2.xlsx2. Manipulate the Data Step 3: Find and Remove Duplicate Data1. Combine Data From Database and Dataset2. Get data that are exist in Dataset but notexist in Database based on ID Step 4: Insert New Data into Database1. Insert non-duplicate data into database2. Read updated data in database Quiz 2: Insert New Data Into Database (Exclude Duplicate Data)Insert new data (non-duplicate) from demographic3.xlsx into table demographic_[your name].Non-duplicate data is based on ID and Negara. Connect to PostgreSQLRead Filedemographic2.xlsxSelect TableRead Data inSelected TableRename Column NameMatch with ColumnIn DatabaseConvert ID ColumnFrom Integer to StringCombine Data FromDataset with Database(Get Unmatching Data)Insert Data in DatasetInto DatabaseRead InsertedDataCombine Data FromDataset with Database(Get Unmatching Data)Connect to PostgreSQLConnect to PostgreSQLRead InsertedDataRename Column NameMatch with ColumnIn DatabaseRead Data inSelected TableSelect TableInsert Data in DatasetInto DatabaseRead Filedemographic3.xlsxConvert ID ColumnFrom Integer to String PostgreSQLConnector Excel Reader DB Table Selector DB Reader Table Manipulator Number To String Joiner DB Insert DB Reader Joiner PostgreSQLConnector PostgreSQLConnector DB Reader Table Manipulator DB Reader DB Table Selector DB Insert Excel Reader Number To String Exercise 2: Insert New Data Into Database (Exclude Duplicate Data)1. Read Data From Database2. Read Data From File3. Find and Remove Duplicate Data4. Insert New Data Into Database5. Read Updated Data In Database Step 1: Read Data From Database1. Connect to PostgreSQL2. Select demographic_[your name] table3. Read Data from Selected Table Step 2: Read Data From File1. Read Data form demographic2.xlsx2. Manipulate the Data Step 3: Find and Remove Duplicate Data1. Combine Data From Database and Dataset2. Get data that are exist in Dataset but notexist in Database based on ID Step 4: Insert New Data into Database1. Insert non-duplicate data into database2. Read updated data in database Quiz 2: Insert New Data Into Database (Exclude Duplicate Data)Insert new data (non-duplicate) from demographic3.xlsx into table demographic_[your name].Non-duplicate data is based on ID and Negara. Connect to PostgreSQLRead Filedemographic2.xlsxSelect TableRead Data inSelected TableRename Column NameMatch with ColumnIn DatabaseConvert ID ColumnFrom Integer to StringCombine Data FromDataset with Database(Get Unmatching Data)Insert Data in DatasetInto DatabaseRead InsertedDataCombine Data FromDataset with Database(Get Unmatching Data)Connect to PostgreSQLConnect to PostgreSQLRead InsertedDataRename Column NameMatch with ColumnIn DatabaseRead Data inSelected TableSelect TableInsert Data in DatasetInto DatabaseRead Filedemographic3.xlsxConvert ID ColumnFrom Integer to StringPostgreSQLConnector Excel Reader DB Table Selector DB Reader Table Manipulator Number To String Joiner DB Insert DB Reader Joiner PostgreSQLConnector PostgreSQLConnector DB Reader Table Manipulator DB Reader DB Table Selector DB Insert Excel Reader Number To String

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-11-21
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!