Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • DB Numeric-Binner
NodeNode / Manipulator

DB Numeric-Binner

DB Query
Drag & drop
Like
Copy short link

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
    test123
    assetslambekov > Public > workflow_group > test123
    assetslambekov
  2. Go to item
    test1
    assetslambekov > Public > workflow_group > test1
    assetslambekov
  3. Go to item
    Database Binning
    Database Sqlite Binning
    This workflow demonstrates the different database binner nodes that allow you to create n…
    knime > Examples > 01_Data_Access > 02_Databases > 04_Binning_in_Databases
    knime
  4. Go to item
    Database Binning
    Database Sqlite Binning
    This workflow demonstrates the different database binner nodes that allow you to create n…
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 1_DB > 4_Examples > 04_Binning_in_Databases
    knime
  5. Go to item
    Database Binning
    Database Sqlite Binning
    This workflow demonstrates the different database binner nodes that allow you to create n…
    haoran > Public > 01_Data_Access > 02_Databases > 04_Binning_in_Databases
    haoran
  6. Go to item
    Preparing and Exploring Customer Data with KNIME and Snowflake (ELT)
    Snowflake ELT Customer Intelligence
    +5
    This workflow is an example of how to read different data files in KNIME and upload it to…
    knime > Examples > 40_Partners > 07_Snowflake > 01a_Snowflake_ELT
    knime
  7. Go to item
    Providing an Interactive Data App with KNIME and Snowflake
    Snowflake Customer Intelligence CI
    +5
    This workflow is an example of how to turn Snowflake data into an interactive Data App th…
    knime > Examples > 40_Partners > 07_Snowflake > 04_Snowflake_Dynamic_Data_App
    knime
  8. Go to item
    DB_practice_v01
    khs > Public > DB_practice_v01
    khs
  1. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits