Hub
NodeNode / Manipulator

DB Row Filter
Drag & drop
Like
Copy short link

This node allows rows to be filtered from the input DB Data table so that the resulting DB Data table will only contain the rows that match the specified filter conditions.
Within the dialog, an SQL WHERE clause is interactively created by adding and grouping conditions.

Node details

Input ports
  1. Type: DB Data
    DB Data
    DB Data to apply filtering.
Output ports
  1. Type: DB Data
    Filtered DB Data
    DB Data with matching rows.

Extension

The DB Row Filter node is part of this extension:

Related workflows & nodes

  1. Fetch Data from Database
    Life Sciences Database SQLite
    This example workflow shows how to retrieve data from SQLite database. Specifically, it s…
    knime > Life Sciences > Workflow_Snippets > Fetch_Data_from_Database
  2. Database Data Manipulation
    kzhqtt > Public > _WA_American-Time-Use-Survey > Database Data Manipulation
  3. 02 Database Data Manipulation
    database SQLite
    Exercise for database data manipulation. Write a local data table into a database. Aggreg…
    mcmas1999 > Assignments > Lab 04 > Project 4 - mickelma > Exercises > 02 Database Data Manipulation
  4. 01 Practicing with Traditional Databases
    big data database
    SOLUTION to an exercise of the L4-BD Introduction to Big Data with KNIME Analytics Platfo…
    maarit > Public > E-Learning > Big Data Course > 01 Practicing with Traditional Databases Solution
  5. 02 Database Data Manipulation
    armourbl > Public > 4015C - Project 4 > Lab 4 - Workflow > 02 Database Data Manipulation
  6. 02 Database Data Manipulation
    database SQLite
    Exercise for database data manipulation. Write a local data table into a database. Aggreg…
    bojesphob > Public > Lab 4 > L2-DS Files > Exercises > 02 Database Data Manipulation
  7. Databases - Advanced Usage
    database sqlite
    This workflow shows a KNIME workflow with a number of database nodes that directly work i…
    knime > Examples > 01_Data_Access > 02_Databases > 02_Database_Advanced_Example
  8. Databases - Advanced Usage
    database sqlite
    This workflow shows a KNIME workflow with a number of database nodes that directly work i…
    lcs > Public > 01_Data_Access > 02_Databases > 02_Database_Advanced_Example
  9. 03 DB Modelling Exercise
    Big Data Education
    Big Data Course DB Exercise #3
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 1_DB > 2_Exercises > 03_DB_Modelling
  10. Databases - Advanced Usage
    database sqlite
    This workflow shows a KNIME workflow with a number of database nodes that directly work i…
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 1_DB > 4_Examples > 02_Database_Advanced_Example