NodeDatabase Numeric-Binner (legacy)


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.

Input Ports

  1. Port Type: Database Query
    Data to define bins

Output Ports

  1. Port Type: Database Query
    Data with bins defined
  2. Port Type: PMML
    PMML document containing binning parameters.