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
  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
  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
  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
  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
  6. 20150915_deleteMinMax
    iris > Public > 02_ForumExamples > 20150915_deleteMinMax
  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 > Education > Courses > L4-CH Introduction to Working with Chemical Data > exercises > 04_SimilaritySearch
  8. 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
  9. rowfilter_w-newline
    lukass > Forum > rowfilter_w-newline
  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 > Life Sciences > Events > 2022_05_08_GCC > exercise > Similarity_Search_Exercise