Hub
Pricing About
NodeNode / Manipulator

DB Numeric-Binner

DBQuery
Drag & drop
Like

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, only one column will be selectable. You can enable "CASE" support in the Advanced tab of the corresponding DB Connector node

Node details

Input ports
  1. Type: DB Data
    DB Data
    DB Data to define bins.
Output ports
  1. Type: DB Data
    Binned DB Data
    DB Data with bins defined.
  2. Type: PMML
    PMML Model
    PMML document containing binning parameters.

Extension

The DB Numeric-Binner node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
  2. Go to item
  3. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits