Icon

Exercise1

Chapter 2 / Exercise 1
Workflow: Chapter2/Exercise1 This exercise is about writing data into a databaseand while doing so it prepares the data for the nextexercises.Reads cars-85.csv file and - writes the first 20 rows into a database- writes it all into a databaseAs a database use SQLite database in KBCBook.sqlite file extract first 20 rowsread filecars-85.csvin KCBdatawrite first 20 rows ofcars85.csv dataset intoKCBBook.sqlite database table cars85firsthalfusing DB Writer node connect toSQLite databaseKCBBook.sqlitewrite all cars85data set into KCBBook.sqlitedatabase usingDB Writer node Row Filter File Reader DB Writer SQLite Connector DB Writer Workflow: Chapter2/Exercise1 This exercise is about writing data into a databaseand while doing so it prepares the data for the nextexercises.Reads cars-85.csv file and - writes the first 20 rows into a database- writes it all into a databaseAs a database use SQLite database in KBCBook.sqlite file extract first 20 rowsread filecars-85.csvin KCBdatawrite first 20 rows ofcars85.csv dataset intoKCBBook.sqlite database table cars85firsthalfusing DB Writer node connect toSQLite databaseKCBBook.sqlitewrite all cars85data set into KCBBook.sqlitedatabase usingDB Writer node Row Filter File Reader DB Writer SQLite Connector DB Writer

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: 2020-05-26
Last update: 2024-05-01
Created with KNIME version: v4.0.0
Tags: BooksKNIME Advanced LuckexercisedatabaseDatabase Accessdatabase writing

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

Try NodePit Runner!