0 ×

Database Numeric-Binner (legacy)

KNIME Base Nodes version 4.0.1.v201908131444 by KNIME AG, Zurich, Switzerland

This node is part of the legacy database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation.

For each column a number of intervals - known as bins - can be defined. Each of these bins is given a unique name (for this column), a defined range, and open or closed interval borders. They automatically ensure that the ranges are defined in descending order and that interval borders are consistent. In addition, each column is either replaced with the binned, string-type column, or a new binned, string-type column is appended.

Please note, that if the underlying database does not support "CASE" statements, binning of only one column is supported.

Options

Select Column:
First select a column (left side) and then use the "Add" button (right side) to create the desired number of bins. Each bin can be modified in the lower part of this panel once it has been selected. Each interval has to be defined independently or can be removed using the "Remove" button. Note that the range as well as the bin borders can be automatically adjusted, if necessary. The first bin's left and the last bin's right value are automatically defined to infinitely cover the entire numeric axes in this direction. Furthermore, each bin's left and right value can be included or excluded from this bin by selecting the desired bracket: '[' or ']'.
Please note, that if the underlying database does not support "CASE" statements, binning of only one column is supported.
Append new column:
If selected, a new column name can be specified. This name is given to the new binned column that is appended to the table; the input column remains unchanged in the data.

Input Ports

Data to define bins

Output Ports

Data with bins defined
PMML document containing binning parameters.

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Installation

To use this node in KNIME, install KNIME Base Nodes from the following update site:

KNIME 4.0
Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.