Icon

Exercise 4

Exercise 3: Updating Column Value with ConditionUpdate Column Level in demographic_[your name] to the value of Column Level in advisory_[your name] table and travel_advisories2.csvwith certain condition to be applied as below1. Only Update data if the difference between population 2019 and population 2019 is Positive2. Only Update data for benua "Europe" and "Asia". for benua "Asia" exclude data for sub_benua "Eastern Asia" Step 1: Read Existing Data of demographic table1. Connect to Database2. Set all value in Column level to NULL3. Select Updated Table4. Read Updated Table Step 2: Read and Update Data of advisory table1. Connect and Read advisory table2. Read data from file travel_advisory.csv 3. Insert Non-Duplicate data in travel_advisory.csv into advisory table Step 3: Transforming and Filtering the Data1. Transform and Filter Data based on the condition given2. Set rules to assign Level value based on advisory table data Step 4: Update Column Value in Database1. Update column level in demographic table by using DB Update2. Read Updated Data Exercise 3: Updating Column Value with ConditionUpdate Column Level in demographic_[your name] to the value of Column Level in advisory_[your name] table and travel_advisories2.csvwith certain condition to be applied as below1. Only Update data if the difference between population 2019 and population 2019 is Positive2. Only Update data for benua "Europe" and "Asia". for benua "Asia" exclude data for sub_benua "Eastern Asia" Step 1: Read Existing Data of demographic table1. Connect to Database2. Set all value in Column level to NULL3. Select Updated Table4. Read Updated Table Step 2: Read and Update Data of advisory table1. Connect and Read advisory table2. Read data from file travel_advisory.csv 3. Insert Non-Duplicate data in travel_advisory.csv into advisory table Step 3: Transforming and Filtering the Data1. Transform and Filter Data based on the condition given2. Set rules to assign Level value based on advisory table data Step 4: Update Column Value in Database1. Update column level in demographic table by using DB Update2. Read Updated Data

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!