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.

  1. Big Data Analytics - Model Selection to Predict Flight Departure Delays on Hive & Spark

    data blending data science machine learning Hadoop Spark model selection data preparation ETL airline data set
    This workflow trains a number of data analytics models on Hadoop and Spark and automatically selects the best model to p…
    Users > knime > Examples > 50_Applications > 28_Predicting_Departure_Delays

  2. Database Binning

    This workflow demonstrates the different database binner nodes that allow you to create new binning columns for numerica…
    Users > knime > Examples > 01_Data_Access > 02_Databases

Extension

This node is part of the extension

KNIME Core

 v4.0.0

Short Link

Drag node into KNIME Analytics Platform