DB Numeric-Binner

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

Icon
Data to define bins

Output Ports

Icon
Data with bins defined
Icon
PMML document containing binning parameters.

Views

This node has no views

Workflows

  • No workflows found

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.