Icon

11. Database - solution

Database - Solution
Activity: Databases - Connect to the H2 database, using the H2 Connector node. The database is here "knime.workflow\..\..\data\database.mv.db"- Write the Fully Joined Data into the Database as a new table called "adult"- Read the "adult" table in the database- Group the data by products and count the number of occurrences- Filter the adult datatable to only contain products that occur more often than 1000 times- Read the filtered table into a KNIME data table (Triangle ports) 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 H2 database, using the H2 Connector node. The database is here "knime.workflow\..\..\data\database.mv.db"- Write the Fully Joined Data into the Database as a new table called "adult"- Read the "adult" table in the database- Group the data by products and count the number of occurrences- Filter the adult datatable to only contain products that occur more often than 1000 times- Read the filtered table into a KNIME data table (Triangle ports) 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: 2019-08-19
Last update: 2020-03-23
Created with KNIME version: v4.0.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!