Icon

Exercise 5

Exercise 5: Merge two table1. Connect and Read demographic table.2. Create life table by using data form file life.xlsx3. Manipulate Table demographic4. Merge table life to the table demographic Step 1: Connect and Read demographic table Step 2: Create table life by using data from life.xlsx Step 3: Manipulate demograpahic table for merging Step 4: Merge Two Table Quiz 5: Merge two tableMerge column Female and Male in table life with table demographic base on negara.Update all value for column life, Female and Male in table demographic by using dataset life2.xlsx based on negara. Connect to PostgreSQLAdd New Columnnamed as "life" Connect to PostgreSQLCreate life tablein DatabaseInsert Data in DatasetInto DatabaseRead Inserted DataSelect demographictableRead DataRead from Filelife.xlsxFilter Out UnmatchedDataMerge Column lifeinto demogrpahic tableConnect to PostgreSQLRead DataConnect to PostgreSQLSelect demographictableRead DataFilter Out UnmatchedDataSelect lifetableRead DataConnect to PostgreSQLAdd New Columnnamed as "Female" and "Male"Merge Column lifeinto demogrpahic tableRead DataRead data fromlife2.xlsxConnect to PostgreSQLUpdate Column1. life2. Female3. MaleRead Data PostgreSQLConnector DB SQL Executor PostgreSQLConnector DB Table Creator DB Insert DB Reader DB Table Selector DB Reader Excel Reader Joiner DB Merge PostgreSQLConnector DB Reader PostgreSQLConnector DB Table Selector DB Reader Joiner DB Table Selector DB Reader PostgreSQLConnector DB SQL Executor DB Merge DB Reader Excel Reader PostgreSQLConnector DB Update DB Reader Exercise 5: Merge two table1. Connect and Read demographic table.2. Create life table by using data form file life.xlsx3. Manipulate Table demographic4. Merge table life to the table demographic Step 1: Connect and Read demographic table Step 2: Create table life by using data from life.xlsx Step 3: Manipulate demograpahic table for merging Step 4: Merge Two Table Quiz 5: Merge two tableMerge column Female and Male in table life with table demographic base on negara.Update all value for column life, Female and Male in table demographic by using dataset life2.xlsx based on negara. Connect to PostgreSQLAdd New Columnnamed as "life" Connect to PostgreSQLCreate life tablein DatabaseInsert Data in DatasetInto DatabaseRead Inserted DataSelect demographictableRead DataRead from Filelife.xlsxFilter Out UnmatchedDataMerge Column lifeinto demogrpahic tableConnect to PostgreSQLRead DataConnect to PostgreSQLSelect demographictableRead DataFilter Out UnmatchedDataSelect lifetableRead DataConnect to PostgreSQLAdd New Columnnamed as "Female" and "Male"Merge Column lifeinto demogrpahic tableRead DataRead data fromlife2.xlsxConnect to PostgreSQLUpdate Column1. life2. Female3. MaleRead DataPostgreSQLConnector DB SQL Executor PostgreSQLConnector DB Table Creator DB Insert DB Reader DB Table Selector DB Reader Excel Reader Joiner DB Merge PostgreSQLConnector DB Reader PostgreSQLConnector DB Table Selector DB Reader Joiner DB Table Selector DB Reader PostgreSQLConnector DB SQL Executor DB Merge DB Reader Excel Reader PostgreSQLConnector 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!