Icon

04_​Binning_​in_​Databases

Database Binning
This workflow demonstrates the different database binner nodes that allow you to create new binning columns for numerical columns. For more information see the workflow metadata. Find it here: View -> Description. Have a look at the result once a Binner node is executed, byopening the "Binned DB Data" view via the nodes contextmenu and clicking the "Cache no. of rows" button You can also bin several cloumns at the same time if the database supports CASE e.g. MySQL, Postgres, Oracle, etc.Define the boundaries of the bins yourselfDefine the number of binsand let KNIME find the rightbin boundariesDefine the boundaries of the bins yourselfApply an existing binning schema to new data Create ExampleTable DB Numeric-Binner DB Numeric-Binner DB Auto-Binner DB Numeric-Binner DB Apply-Binner This workflow demonstrates the different database binner nodes that allow you to create new binning columns for numerical columns. For more information see the workflow metadata. Find it here: View -> Description. Have a look at the result once a Binner node is executed, byopening the "Binned DB Data" view via the nodes contextmenu and clicking the "Cache no. of rows" button You can also bin several cloumns at the same time if the database supports CASE e.g. MySQL, Postgres, Oracle, etc.Define the boundaries of the bins yourselfDefine the number of binsand let KNIME find the rightbin boundariesDefine the boundaries of the bins yourselfApply an existing binning schema to new dataCreate ExampleTable DB Numeric-Binner DB Numeric-Binner DB Auto-Binner DB Numeric-Binner DB Apply-Binner

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: Berthold
Created at: 2015-12-08
On NodePit since: 2019-07-12
Last update: 2024-04-18
Created with KNIME version: v4.1.0
Tags: databasesqlitebinning

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

Try NodePit Runner!