Icon

03_​Row_​Filtering

Row Filter
This workflow showcases different filtering functions of the Row Filter node for various tasks on different types of data Pattern matchingString matching criterion With wild card & Include Simple Include With wild card & Exclude Range CheckingNumber matching criterion Number in range & Include Number in range & Exclude Matching RowID value with wldcard &RegExInclude & Exclude Matching row number Include & Exclude Matching Missing Values Include &Exclude Any matching criterion in a collectiontype column only sales in"Germany"only sales withquantity < 2& quantity > 5only sales withquantity >=2only sales withquantity >=2 &<=5only sales withmissing value in quantityonly sales withno missing quantityonly top 10 rowsonly last N-10 rowsonly rowswith RowID starting with Row1* only rowswith RowID not startingwith Row1*only sales incountries ending with a or Aonly sales incountries starting with u or Uonly sales incountries starting with Uonly sales incountries notstarting with u or Uonly sales withquantity = 2all values in one columnas collectiononly salesin Germanyfrom a collection columnsales records 2008-2011 Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Create CollectionColumn Row Filter File Reader This workflow showcases different filtering functions of the Row Filter node for various tasks on different types of data Pattern matchingString matching criterion With wild card & Include Simple Include With wild card & Exclude Range CheckingNumber matching criterion Number in range & Include Number in range & Exclude Matching RowID value with wldcard &RegExInclude & Exclude Matching row number Include & Exclude Matching Missing Values Include &Exclude Any matching criterion in a collectiontype column only sales in"Germany"only sales withquantity < 2& quantity > 5only sales withquantity >=2only sales withquantity >=2 &<=5only sales withmissing value in quantityonly sales withno missing quantityonly top 10 rowsonly last N-10 rowsonly rowswith RowID starting with Row1* only rowswith RowID not startingwith Row1*only sales incountries ending with a or Aonly sales incountries starting with u or Uonly sales incountries starting with Uonly sales incountries notstarting with u or Uonly sales withquantity = 2all values in one columnas collectiononly salesin Germanyfrom a collection columnsales records 2008-2011 Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Create CollectionColumn Row Filter File Reader

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: rosy
Created at: 2016-09-19
On NodePit since: 2019-07-12
Last update: 2024-04-26
Created with KNIME version: v4.4.1
Tags: row filterrow 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!