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. Austin Bike-sharing with Google BigQuery
    Google BigQuery DB query cloud
    This workflow performs a connection to the Austin Bikeshare dataset, hosted among the Google BigQuery public datasets. …
    knime > Examples > 10_Big_Data > 01_Big_Data_Connectors > 05_Austin bike sharing with Google BigQuery
  2. Explore Scientific Data Stored on BigQuery using KNIME
    BigQuery SciWalker clinical trial clinical study disease
    This example shows how KNIME Analytics Platform can be used to explore and analyze data stored in Google BigQuery. Data…
    knime > Examples > 08_Other_Analytics_Types > 02_Chemistry_and_Life_Sciences > 06_BigQuery_SciWalker_Exploration
  3. 04 DB WritingToDB Exercise
    Big Data Education
    Big Data Course DB Exercise #4
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 1_DB > 2_Exercises > 04_DB_WritingToDB
  4. Spark SQL meets Hive SQL
    Spark Hive Hadoop Big Data SQL in-database
    This workflow builds a line plot of the age distribution for men and women in Maine (US) over the last 5 years. In part…
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 3_Spark > 4_Examples > 07_SparkSQL_meets_HiveQL
  5. 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 stand…
    tobias.koetter > Public > DB > DB_to_DB
  6. Database - Solution
    database H2 database preprocessing education
    Solution to exercise 10 for KNIME Analytics Platform for Data Scientists course - Write data into a database - Read dat…
    pm_hannover > Public > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > solutions > 10. Database - solution
  7. Advanced Row Filtering
    row filter data manipulation ETL preprocessing
    Additionally to simple filtering on nominal columns with the Row Filter node this workflow gives examples for: - Filter…
    yzer > Public > 04_Advanced_Row_Filters
  8. Rossmann - DB - Time Series
    mwysocki > Public > Rossmann - DB - Time Series
  9. Advanced Row Filtering
    row filter data manipulation ETL preprocessing
    Additionally to simple filtering on nominal columns with the Row Filter node this workflow gives examples for: - Filter…
    knime > Examples > 02_ETL_Data_Manipulation > 01_Filtering > 04_Advanced_Row_Filters
  10. 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 …
    lcs > Public > 01_Data_Access > 02_Databases > 02_Database_Advanced_Example