Icon

11. Database

Database
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) Fully Joined Data H2 Connector 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) 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: 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!