0 ×

04_​Binning_​in_​Databases

Workflow

Database Binning
databasesqlitebinning
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

Download

Get this workflow from the following link: Download

Nodes

04_​Binning_​in_​Databases consists of the following 9 nodes(s):

Plugins

04_​Binning_​in_​Databases contains nodes provided by the following 3 plugin(s):