Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • DB Row Filter
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:

  1. Go to item

Related workflows & nodes

  1. Go to item
    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. Go to item
    Database Data Manipulation
    kzhqtt > Public > _WA_American-Time-Use-Survey > Database Data Manipulation
    kzhqtt
  3. Go to item
    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. Go to item
    Lab 3.2
    doctorbrunson > Lab 3.2 > Lab 3.2
    doctorbrunson
  5. Go to item
    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. Go to item
    Filter multiple ranges from DB
    kathrin > Forum Questions > Filter multiple ranges from DB
    kathrin
  7. Go to item
    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. Go to item
    02 Database Data Manipulation
    armourbl > Public > 4015C - Project 4 > Lab 4 - Workflow > 02 Database Data Manipulation
    armourbl
  9. Go to item
    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. Go to item
    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
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. 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