Icon

02_​DB_​InDB_​Processing

02 DB InDB Processing Exercise
Exercise: 02_DB_InDB_Processing This workflow connects to the database (SQLite) newCensus.sqlite to read tables ss13hme (house data) and ss13pme(person data) containing data for the US state of Maine.Now you need to create 5 tables: 1. join ss13hme and ss13pme on SERIALNO. Remove all columns named PUMA* and PWGTP* from both tables. 2. filter all rows from ss13pme where COW is NULL 3. filter all rows from ss13pme where COW is NOT NULL 4. calculate average AGEP for the different SEX groups 5. Optional. Sort the data rows by descending AGEP and extract top 10 only. Hint: Use LIMIT to restrict the number of rowsreturned by the db.For all tasks, at the end, you need to load the data into a KNIME data table. connect to 1_Data/newCensus.sqliteselect * from ss13hmeselect * from ss13pme SQLite Connector DB Table Selector DB Table Selector Exercise: 02_DB_InDB_Processing This workflow connects to the database (SQLite) newCensus.sqlite to read tables ss13hme (house data) and ss13pme(person data) containing data for the US state of Maine.Now you need to create 5 tables: 1. join ss13hme and ss13pme on SERIALNO. Remove all columns named PUMA* and PWGTP* from both tables. 2. filter all rows from ss13pme where COW is NULL 3. filter all rows from ss13pme where COW is NOT NULL 4. calculate average AGEP for the different SEX groups 5. Optional. Sort the data rows by descending AGEP and extract top 10 only. Hint: Use LIMIT to restrict the number of rowsreturned by the db.For all tasks, at the end, you need to load the data into a KNIME data table. connect to 1_Data/newCensus.sqliteselect * from ss13hmeselect * from ss13pmeSQLite Connector DB Table Selector DB Table Selector

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: koetter
Created at: 2015-07-31
On NodePit since: 2020-04-22
Last update: 2024-05-02
Created with KNIME version: v4.3.0
Tags: Big DataEducation

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!