NodeDatabase 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. 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.

  1. Database Binning

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

  2. 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 flight delay
    This workflow trains a number of data analytics models on Hadoop and Spark and automatically selects the best model to p…
    knime > Examples > 50_Applications > 28_Predicting_Departure_Delays > 02_Scaling_Analytics_w_BigData