DB Numeric-Binner (Labs)

Manipulator

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: DB Data Data to define bins

Output Ports

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

Find here

KNIME Labs > DB (Labs) > Query

Make sure to have this extension installed: