Icon

10. Database - solution

Database - Solution
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 Write adult tableinto databaseRead data intoKNIMEGroup by productsCount occurrencescount > 1000Filter to productsin bottom tableRead adult table Fully Joined Data H2 Connector DB Writer DB Reader DB GroupBy DB Row Filter DB Joiner DB Table Selector 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 Write adult tableinto databaseRead data intoKNIMEGroup by productsCount occurrencescount > 1000Filter to productsin bottom tableRead adult table Fully Joined Data H2 Connector DB Writer DB Reader DB GroupBy DB Row Filter DB Joiner DB Table Selector

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-12-17
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!