Icon

2019_​10_​31_​Special_​Refrence_​Row_​Filtering

Special Reference Row Filtering
Special Reference Row FilteringThis workflow demonstrates how to filter rows in Input table based on values from Reference table. Rule is that rowshould be filtered if contains a word from Reference table. In this example all rows that have word(letter) a as a seperateword will be filtered.Forum link: https://forum.knime.com/t/row-filter/19174 Input dataReference dataSplit each wordCreate one columnAdd info to matching wordsGroup rowsAdd InfoGet proper RowIDsAdd info to original table by joining on RowIDDrop InfoAdd info for non matched rowsFilter based on Info Table Creator Table Creator Cell Splitter Unpivoting Cell Replacer GroupBy ConstantValue Column RowID Joiner Column Filter Rule Engine Row Filter Special Reference Row FilteringThis workflow demonstrates how to filter rows in Input table based on values from Reference table. Rule is that rowshould be filtered if contains a word from Reference table. In this example all rows that have word(letter) a as a seperateword will be filtered.Forum link: https://forum.knime.com/t/row-filter/19174 Input dataReference dataSplit each wordCreate one columnAdd info to matching wordsGroup rowsAdd InfoGet proper RowIDsAdd info to original table by joining on RowIDDrop InfoAdd info for non matched rowsFilter based on Info Table Creator Table Creator Cell Splitter Unpivoting Cell Replacer GroupBy ConstantValue Column RowID Joiner Column Filter Rule Engine Row Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Johnny
Created at: 2019-01-03
On NodePit since: 2019-10-31
Last update: 2024-04-18
Created with KNIME version: v4.0.2
Tags: Data ManipulationReference Row Filtering

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!