NodeDB Row Filter

Manipulator

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.

Input ports
  1. DB Data Type: DB Data
    DB Data to apply filtering.
Output ports
  1. Filtered DB Data Type: DB Data
    DB Data with matching rows.
  1. DB to DB Data Transfer
    db migration streaming data transfer
    This workflow demonstrates the transfer of data between two different database systems. The upper branch uses the standa…
    tobias.koetter > Public > DB > DB_to_DB
  2. Database - Solution
    database H2 database preprocessing education
    Solution to the exercise 11 for KNIME User Training - Writing data into a database - Reading data from a database - Aggr…
    knime > Education > 01 KNIME User Training > solutions > 11. Database - solution
  3. 01_Hive_Modeling_Exercise_Solution
    Big Data Education
    Big Data Course Hadoop Exercise #1 Solution Make sure you have executed the /2_Hadoop/2_Exercises/00_Setup_Hive_Table wo…
    knime > Education > 04 KNIME Big Data Course > 2_Hadoop > 3_Solutions > 01_Hive_Modelling
  4. Databases - Advanced Usage
    database sqlite
    This workflow shows a KNIME workflow with a number of database nodes that directly work inside a database. It uses the f…
    knime > Examples > 01_Data_Access > 02_Databases > 02_Database_Advanced_Example
  5. 04_DB_WritingToDB_Exercise
    Big Data Education
    Big Data Course DB Exercise #4
    knime > Education > 04 KNIME Big Data Course > 1_DB > 2_Exercises > 04_DB_WritingToDB
  6. 03_DB_Modelling_Exercise_Solution
    Big Data Education
    Big Data Course DB Exercise #3 Solution
    knime > Education > 04 KNIME Big Data Course > 1_DB > 3_Solutions > 03_DB_Modelling
  7. Big Data Preprocessing
    Hive Hadoop Big Data SQL in-database Big Data Education
    This workflow demonstrates the usage of the database nodes in conjunction with the Hive Connector node, which is part of…
    knime > Education > 04 KNIME Big Data Course > 2_Hadoop > 4_Examples > 01_Big_Data_Preprocessing_Example
  8. Explore Scientific Data Stored on BigQuery using KNIME
    BigQuery SciWalker clinical trial clinical study disease
    To be able to connect to BigQuery using the DB Connector node following steps need to be done: 1) Download the freely av…
    martyna > Public > BigQuery_SciWalker_Exploration
  9. Rossmann - DB - Time Series(2)
    mwysocki > Public > Rossmann - DB - Time Series(2)
  10. 03_DB_Modelling_Exercise
    Big Data Education
    Big Data Course DB Exercise #3
    knime > Education > 04 KNIME Big Data Course > 1_DB > 2_Exercises > 03_DB_Modelling