Icon

Exercise2

<p><strong>Chapter 3/Exercise 2</strong></p><p>This exercise completes Exercise 1 in Chapter 3.</p><p>The full sentences, built with the <em>Expression </em>nodes and stored in the "Final sentence" column, are written here into a table named "Chapter3Exercise2" in the SQLite Database named <em>KBLBook.sqlite</em> (available in the KBLdata folder).</p>

URL: KNIME Beginner's Luck (Book Homepage) https://www.knime.com/knimepress/beginners-luck

Workflow: Chapter 3/Exercise 2

This exercise completes Exercise 1 in Chapter 3.

The full sentences, built with the Expression nodes and stored in the "Final sentence" column, are written here into a table named "Chapter3Exercise2" in the SQLite Database named KBLBook.sqlite (available in the KBLdata folder).

This part was built in Chapter 3/Exercise 1

Writing resulting data table into an SQLite database table

Just for inspection

yellow-small.csv
CSV Reader
Rename columns asspecified in fileballons.names
Column Renamer
Rule for"inflated" vs. "not inflated"
Expression
Write data to table"Chapter3Exercise2" in KBLBook.sqlite
DB Writer
Select table "Chapter3Exercise2"
DB Table Selector
KBLBook.sqliteUsing relative path withknime:// protocol
SQLite Connector
Building final sentence
Expression
DB Reader

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: 2025-12-15
Last update: 2026-01-05
Created with KNIME version: v5.9.0
Tags: EducationKNIMEPressSQLiteString manipulation

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

Try NodePit Runner!