Chapter 2 / Exercise 2
Reads dataset cars-85 from KCBBook.sqlite DB, prepared in exercise1.
The goal of this exercise is to read data from a database and practice a bit of in-database processing with database nodes and SQL queries.
To read the database start with a connector node, either the generic DB Connector node or the dedicated SQLite Connector node.
Pre-process the dataset with database nodes or SQL queries as follows:
1. exclude 'symboling' and 'normalized losses'
2. keep only bmw and audi cars
To use this workflow in KNIME, download it from the below URL and open it in KNIME:
Download WorkflowDeploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com.
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.