Icon

20230203_​filter_​six_​rows_​after_​digit_​v0

20230203_20230203_filter_six_rows_after_digit

https://forum.knime.com/t/filter-a-specific-number-of-rows-or-the-maximum-number-of-rows-within-a-certain-range/60978

filter by consecutive string approach filter by row position approach Challenge DataregexMatcher()digit == TRUElag $A% (+1)identify repeated rowsexclude missedlag $A% (-1)regexMatcher()digit == 1numericrank digitgroupnumber of rows... to Variablerank group rowsROWINDEXfilter 6 rows after digit Excel Reader String Manipulation Moving Aggregation Rule Engine Rule-basedRow Filter Lag Column Rule Engine Moving Aggregation Extract TableDimension Table Rowto Variable Rank Math Formula Rule-basedRow Filter filter by consecutive string approach filter by row position approach Challenge DataregexMatcher()digit == TRUElag $A% (+1)identify repeated rowsexclude missedlag $A% (-1)regexMatcher()digit == 1numericrank digitgroupnumber of rows... to Variablerank group rowsROWINDEXfilter 6 rows after digit Excel Reader String Manipulation Moving Aggregation Rule Engine Rule-basedRow Filter Lag Column Rule Engine Moving Aggregation Extract TableDimension Table Rowto Variable Rank Math Formula Rule-basedRow 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: RE90273
Created at: 2023-02-03
On NodePit since: 2023-02-04
Last update: 2024-11-21
Created with KNIME version: v4.7.0

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

Try NodePit Runner!