Icon

10. Database

Database
Activity: Databases- Connect to the database.mv.db database with the H2 Connector node- Write the Fully Joined Data into the database as a new table called adult- Select the adult table in the database- Count the number of records per product- Filter out products that occur less than 1000 times by joining the aggregated and the original database table- Read the filtered database table into a KNIME data table Fully Joined Data H2 Connector Activity: Databases- Connect to the database.mv.db database with the H2 Connector node- Write the Fully Joined Data into the database as a new table called adult- Select the adult table in the database- Count the number of records per product- Filter out products that occur less than 1000 times by joining the aggregated and the original database table- Read the filtered database table into a KNIME data table Fully Joined Data H2 Connector

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: knime
Created at: 2014-06-17
On NodePit since: 2020-04-09
Last update: 2024-04-28
Created with KNIME version: v4.1.0
Tags: databaseH2database preprocessingeducation

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

Try NodePit Runner!