Hub
NodeNode / Manipulator

DB Row Filter

DB Query
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 > Workflow Snippets > Fetch_Data_from_Database
    knime
  2. Database Data Manipulation
    kzhqtt > Public > _WA_American-Time-Use-Survey > Database Data Manipulation
    kzhqtt
  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
    mcmas1999
  4. Lab 3.2
    doctorbrunson > Lab 3.2 > Lab 3.2
    doctorbrunson
  5. 02 Database Data Manipulation
    Database SQLite
    Exercise for database data manipulation. Write a local data table into a database. Aggreg…
    elzamc > Public > MICAH ELZA L2-DS KNIME Analytics Platform for Data Scientists - Advanced > CUSTOM DATA > 02 Database Data Manipulation
    elzamc
  6. Filter multiple ranges from DB
    kathrin > Forum Questions > Filter multiple ranges from DB
    kathrin
  7. 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
    bojesphob
  8. 02 Database Data Manipulation
    armourbl > Public > 4015C - Project 4 > Lab 4 - Workflow > 02 Database Data Manipulation
    armourbl
  9. 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
    knime
  10. 02 Database Data Manipulation - Solution
    Database SQLite
    Solution to an exercise for database data manipulation. Write a local data table into a d…
    knime > Education > Self-Paced Courses > Archive > L2-DS KNIME Analytics Platform for Data Scientists - Advanced (deprecated) > Solutions > 02 Database Data Manipulation - Solution
    knime