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 2018 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 Connect to PostgreSQLInsert Data in DatasetInto DatabaseRead InsertedDataSelect demographictableRead DataSet Column Levelto NULLSelect demographictableRead DataConnect to PostgreSQLSelect advisorytableRead DataReadadvisory2.csvGet Non-DuplicatedataCalculate PopulationDifferenceSet Status forPopulation DifferenceFilter Data WithPopulation Diff Statusis PositiveFilter Data WithBenua is EuropeFilter Data WithBenua is AsiaFilter Data WithSub Benua is not Eastern AsiaCombine AllFiltered DataDefine RuleUpdate Column LevelBased On advisory TableUpdate Table based on IDConnect to PostgreSQLRead Data PostgreSQLConnector DB Insert DB Reader DB Table Selector DB Reader DB SQL Executor DB Table Selector DB Reader PostgreSQLConnector DB Table Selector DB Reader CSV Reader Joiner Math Formula Rule Engine Row Filter Row Filter Row Filter Row Filter Concatenate String Manipulation Rule Engine(Dictionary) DB Update PostgreSQLConnector DB Reader 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 2018 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 Connect to PostgreSQLInsert Data in DatasetInto DatabaseRead InsertedDataSelect demographictableRead DataSet Column Levelto NULLSelect demographictableRead DataConnect to PostgreSQLSelect advisorytableRead DataReadadvisory2.csvGet Non-DuplicatedataCalculate PopulationDifferenceSet Status forPopulation DifferenceFilter Data WithPopulation Diff Statusis PositiveFilter Data WithBenua is EuropeFilter Data WithBenua is AsiaFilter Data WithSub Benua is not Eastern AsiaCombine AllFiltered DataDefine RuleUpdate Column LevelBased On advisory TableUpdate Table based on IDConnect to PostgreSQLRead DataPostgreSQLConnector DB Insert DB Reader DB Table Selector DB Reader DB SQL Executor DB Table Selector DB Reader PostgreSQLConnector DB Table Selector DB Reader CSV Reader Joiner Math Formula Rule Engine Row Filter Row Filter Row Filter Row Filter Concatenate String Manipulation Rule Engine(Dictionary) DB Update PostgreSQLConnector DB Reader

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