Icon

Exercise2

Chapter 2 / Exercise 2
Workflow: Chapter2/Exercise2 Reads dataset cars-85 from KCBBook.sqlite DB, prepared in exercise1.The goal of this exercise is to read data from a database and practice a bit of in-database processing with database nodes and SQL queries.To read the database start with a connector node, either the generic DBConnector node or the dedicated SQLite Connector node.Pre-process the dataset with database nodes or SQL queries as follows:1. exclude 'symboling' and 'normalized losses'2. keep only bmw and audi cars connect toKCBBook.sqlitedatabaseSELECT ,,,,,,,,, from cars85 WHERE make = 'bmw' OR make = 'audi'SELECT * from cars85 WHERE make = 'bmw' OR make = 'audi'exclude"symboling" and"normalized losses"exclude"symboling" and"normalized losses"make = 'bmw' ORmake = 'audi'generic connectorto SQLite DBKCBBook.sqliteSELECT * from cars85 get path toSQLite DBKCBBook.sqlite SQLite Connector DB Query Reader DB Table Selector DB Column Filter DB Reader DB Column Filter DB Reader DB Row Filter DB Connector DB Table Selector Get path to DB Workflow: Chapter2/Exercise2 Reads dataset cars-85 from KCBBook.sqlite DB, prepared in exercise1.The goal of this exercise is to read data from a database and practice a bit of in-database processing with database nodes and SQL queries.To read the database start with a connector node, either the generic DBConnector node or the dedicated SQLite Connector node.Pre-process the dataset with database nodes or SQL queries as follows:1. exclude 'symboling' and 'normalized losses'2. keep only bmw and audi cars connect toKCBBook.sqlitedatabaseSELECT ,,,,,,,,, from cars85 WHERE make = 'bmw' OR make = 'audi'SELECT * from cars85 WHERE make = 'bmw' OR make = 'audi'exclude"symboling" and"normalized losses"exclude"symboling" and"normalized losses"make = 'bmw' ORmake = 'audi'generic connectorto SQLite DBKCBBook.sqliteSELECT * from cars85 get path toSQLite DBKCBBook.sqlite SQLite Connector DB Query Reader DB Table Selector DB Column Filter DB Reader DB Column Filter DB Reader DB Row Filter DB Connector DB Table Selector Get path to DB

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
On NodePit since: 2021-08-04
Last update: 2024-04-27
Created with KNIME version: v4.4.0
Tags: BooksKNIME Advanced LuckexercisedatabaseSQLitedatabase access

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

Try NodePit Runner!