Database Numeric-Binner (legacy)

Manipulator

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. Type: Database Query
    Data to define bins

Output Ports

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

Extension

This node is part of the extension

KNIME Core

v4.0.0

Short Link

Drag node into KNIME Analytics Platform