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

  1. Go to item

Related workflows & nodes

  1. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    20150915_deleteMinMax
    iris > Public > 02_ForumExamples > 20150915_deleteMinMax
  7. Go to item
    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. Go to item
    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. Go to item
    rowfilter_w-newline
    lukass > Forum > rowfilter_w-newline
  10. Go to item
    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
  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
Hardturmstrasse 66
8005 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 Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits