Hub
NodeNode / Manipulator

Reference Row Filter

Manipulation Row Filter
Drag & drop
Like
Copy short link

This node allows rows to be filtered from the first table using the second table as reference. Depending on the dialog setting, the rows from the reference table are either included or excluded in the output table.
During the test for in-/exclusion the values of the selected columns of both tables are compared.

Node details

Input ports
  1. Type: Table
    Table to be filtered
    Table from which rows are to be included or excluded
  2. Type: Table
    Reference table
    Table rows used as reference filter
Output ports
  1. Type: Table
    Filtered table
    Table with filtered rows

Extension

The Reference Row Filter node is part of this extension:

Related workflows & nodes

  1. 07_Advanced_Row_Filter - Solution
    E-learning Filtering Education
    Solution to an e-learning course exercise. Filter rows with the Nominal Value Row Filter,…
    stervis > Public > E-Learning > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 07_Advanced_Row_Filter - Solution
    stervis
  2. 07_Advanced_Row_Filter - Solution
    E-learning Filtering Education
    Solution to an e-learning course exercise. Filter rows with the Nominal Value Row Filter,…
    stervis > Public > E-Learning > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 07_Advanced_Row_Filter - Solution
    stervis
  3. 07_Advanced_Row_Filter - Solution
    E-learning Filtering Education
    Solution to an e-learning course exercise. Filter rows with the Nominal Value Row Filter,…
    kartar19 > Public > 07_Advanced_Row_Filter - Solution
    kartar19
  4. 07_Advanced_Row_Filter - Solution
    E-learning Filtering Education
    Solution to an e-learning course exercise. Filter rows with the Nominal Value Row Filter,…
    a2620 > Public > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 07_Advanced_Row_Filter - Solution
    a2620
  5. 07_Advanced_Row_Filter - Solution
    E-learning Filtering Education
    Solution to an e-learning course exercise. Filter rows with the Nominal Value Row Filter,…
    mavalenciaor > Public > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 07_Advanced_Row_Filter - Solution
    mavalenciaor
  6. 20150915_deleteMinMax
    iris > Public > 02_ForumExamples > 20150915_deleteMinMax
    iris
  7. 04_SimilaritySearch
    Chemistry Life Sciences Similarity Search
    +2
    In this exercise we expand our results by finding building blocks similar to those we sel…
    knime > Life Sciences > Events > 2021_09_13_Vienna_Summer_School > Advanced > exercises > 02_SimilaritySearch
    knime
  8. rowfilter_w-newline
    lukass > Forum > rowfilter_w-newline
    lukass
  9. 04_SimilaritySearch
    Chemistry Life Sciences Similarity Search
    +2
    In this exercise we expand our results by finding building blocks similar to those we sel…
    knime > Life Sciences > Events > 2022_05_08_GCC > exercise > Similarity_Search_Exercise
    knime
  10. 04_SimilaritySearch
    Chemistry Life Sciences Similarity Search
    +2
    In this exercise we expand our results by finding building blocks similar to those we sel…
    knime > Education > Courses > L4-CH Introduction to Working with Chemical Data > exercises > 03_SimilaritySearch
    knime