Icon

Exercise3

Chapter 2 / Exercise 3

The goal of this exercise is to practice with the Parameterized DB Query Reader node for looping purpose.

Extract make, nr_doors, length, width, and engine_type from table cars85 in KCBBook.sqlite DB, prepared in exercise1.

Like in the previous exercise, pre-process the dataset to keep only bmw and audi cars. This time though, unlike exercise2, use a Parameterized DB Query Reader node instead of SQL queries and database filter nodes.

Workflow: Chapter2/Exercise3 The goal of this exercise is to practice with theParameterized DB Query Reader node for loopingpurpose.Extract make, nr_doors, length, width, andengine_type from table cars85 in KCBBook.sqlite DB,prepared in exercise1.Like in the previous exercise, pre-process the dataset tokeep only bmw and audi cars. This time though,unlike exercise2, use a Parameterized DB Query Readernode instead of SQL queries and database filter nodes. create list of include make asbmw and audiconnect toKCBBook.sqlitedatabaseloop over column "make"and keep onlybmw and audi carsselect table cars85 Table Creator SQLite Connector ParameterizedDB Query Reader DB Table Selector Workflow: Chapter2/Exercise3 The goal of this exercise is to practice with theParameterized DB Query Reader node for loopingpurpose.Extract make, nr_doors, length, width, andengine_type from table cars85 in KCBBook.sqlite DB,prepared in exercise1.Like in the previous exercise, pre-process the dataset tokeep only bmw and audi cars. This time though,unlike exercise2, use a Parameterized DB Query Readernode instead of SQL queries and database filter nodes. create list of include make asbmw and audiconnect toKCBBook.sqlitedatabaseloop over column "make"and keep onlybmw and audi carsselect table cars85 Table Creator SQLite Connector ParameterizedDB Query Reader 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
On NodePit since: 2023-01-23
Last update: 2024-05-02
Created with KNIME version: v4.3.1
Tags: SQLiteBooksexerciseKNIME Advanced Luckdatabasedatabase connection

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

Try NodePit Runner!