Icon

Exercise1

<p><strong>Chapter 2/Exercise 1</strong></p><p>This exercise shows how to write data into a database while also preparing it for the next exercises.</p><p>The workflow</p><ul><li><p>reads <em>cars-85.csv</em> file,</p></li><li><p>writes the first 20 rows into a database table, and</p></li><li><p>writes the full dataset into a different table in the same database.</p></li></ul><p>As a database use the SQLite database <em>KBCBook.sqlite</em>.</p>

Workflow: Chapter 2/Exercise 1


This exercise shows how to write data into a database while also preparing it for the next exercises.

The workflow

  • reads cars-85.csv file,

  • writes the first 20 rows into a database table, and

  • writes the full dataset into a different table in the same database.

As a database use the SQLite database KBCBook.sqlite.

Accessing database

Accessing data

Writing into a database

Write first 20 rows of cars85.csvinto KCBBook.sqlite DB tablecars85firsthalf
DB Writer
Write full cars85.csv datasetinto KCBBook.sqlite DB
DB Writer
cars-85.csv
CSV Reader
Extract first 20 rows
Row Filter
Connect to SQLite DBKCBBook.sqlite
SQLite Connector

Nodes

Extensions

Links