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. 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.

Nodes

  • No nodes found

Extensions

  • No modules found

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-01
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!