Icon

Exercise 3

Exercise 3: Creating New Column and Update Value For Selected Column1. Connect to Database and Add New Column named as "Level" into table demographic_[your name]2. Read Data form Database and Manipulate Table adcisory_[your name]3. Update COlumn Level Value in demographic_[your name] table to value of Column Level in advisory_[your name] table Step 1: Add New Column in Table1. Connect to Database2. Add New Column using DB SQL Executor3. Select Updated Table4. Read Updated Table Quiz 3: Creating New Column and Update Value For Selected ColumnCreate new column named as "Rank" with Int datatype in demographic_[your name] table.Assign value to the created column to the value of the Column Rank in file rank.xlsx based on the Countries Step 2: Read and Manipulate Data in Table1. Connect to Database, Select table and Read Table2. Rename Column to be Match with Column in Updated Table3. Select, Read and Check new table that has been updated Step 3: Update Column Value Based On Other Column Value inDifferent Table1. Update Column Level Value in table demographic_[your name]based on value of Column Level in table advisory_[your name]based on negara by using DB Update Connect to PostgreSQLAdd New Columnnamed as "Level"Select Updated TableRead DataRename Column NameMatch with Columnin Updated TableRead DataSelect Tableadvisory_[your name]Update Column Level Valuein table demographic to Value in table advisory based on negaraRead DataConnect to PostgreSQLAdd New Columnnamed as "Rank" Read Rank.xlsxUpdate Column Rank ValueRead Data PostgreSQLConnector DB SQL Executor DB Table Selector DB Reader DB SQL Executor DB Reader DB Table Selector DB Update DB Reader PostgreSQLConnector DB SQL Executor Excel Reader DB Update DB Reader Exercise 3: Creating New Column and Update Value For Selected Column1. Connect to Database and Add New Column named as "Level" into table demographic_[your name]2. Read Data form Database and Manipulate Table adcisory_[your name]3. Update COlumn Level Value in demographic_[your name] table to value of Column Level in advisory_[your name] table Step 1: Add New Column in Table1. Connect to Database2. Add New Column using DB SQL Executor3. Select Updated Table4. Read Updated Table Quiz 3: Creating New Column and Update Value For Selected ColumnCreate new column named as "Rank" with Int datatype in demographic_[your name] table.Assign value to the created column to the value of the Column Rank in file rank.xlsx based on the Countries Step 2: Read and Manipulate Data in Table1. Connect to Database, Select table and Read Table2. Rename Column to be Match with Column in Updated Table3. Select, Read and Check new table that has been updated Step 3: Update Column Value Based On Other Column Value inDifferent Table1. Update Column Level Value in table demographic_[your name]based on value of Column Level in table advisory_[your name]based on negara by using DB Update Connect to PostgreSQLAdd New Columnnamed as "Level"Select Updated TableRead DataRename Column NameMatch with Columnin Updated TableRead DataSelect Tableadvisory_[your name]Update Column Level Valuein table demographic to Value in table advisory based on negaraRead DataConnect to PostgreSQLAdd New Columnnamed as "Rank" Read Rank.xlsxUpdate Column Rank ValueRead DataPostgreSQLConnector DB SQL Executor DB Table Selector DB Reader DB SQL Executor DB Reader DB Table Selector DB Update DB Reader PostgreSQLConnector DB SQL Executor Excel Reader DB Update 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-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!