Icon

Exercise3

<p><strong>Chapter 2/Exercise 3</strong></p><p>The goal of this exercise is to practice with the <em>Parameterized DB Query Reader</em> node for looping purpose.</p><p>From table <em>cars85 </em>in the <em>KCBBook.sqlite</em> databsae, prepared in Chapter2/Exercise1, extract:</p><ul><li><p>make</p></li><li><p>nr_doors</p></li><li><p>length</p></li><li><p>width</p></li><li><p>engine_type</p></li></ul><p>Like in the previous exercise, preprocess the dataset to keep only BMW and Audi cars. However, this time, use a <em>Parameterized DB Query Reader</em> node instead of SQL queries and database filter nodes.</p>

Workflow: Chapter 2/Exercise 3


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

From the table cars85 in the KCBBook.sqlite databsae, prepared in Chapter2/Exercise1, extract:

  • make

  • nr_doors

  • length

  • width

  • engine_type

Like in the previous exercise, preprocess the dataset to keep only BMW and Audi cars. However, this time, use a Parameterized DB Query Reader node instead of SQL queries and database filter nodes.

Accessing database

Generate list of car manufacturers

loop over column "make"and keep onlybmw and audi cars
Parameterized DB Query Reader
Select tablecars85
DB Table Selector
Create list of car manufacturers
Table Creator
Connect to SQLite DBKCBBook.sqlite
SQLite Connector

Nodes

Extensions

Links