Icon

Selecting consecutive row of certain size without loop by badger101

NO LOOP APPROACH - THE CODING ROUTE NO LOOP APPROACH - SUBSTITUTION ROUTE Selecting the ones that matchour predetermined criteria.ResultsRevealinginformation onthe new groups.Input Scoring SystemBy default, each row getsan accumulative score of 1as we move from one row to another.The scoring pauseseverytime a row's value becomes a duplicateof its previous row of the same group, oreverytime we hop from one group to a different one.Using the scoresto form new groups.(If the first row has a missing value,it does not affect resultsif it remains missing).InputCombining all rowsfor each groupSubstitutingthe single letters withspace.Using the missing valuesas separators to enlist all elements.Remove rowsaccording to our predetermined rule(s).Reveal all elements.SubstituteColumn 2 with Column 3+any single letterwhen the row is equivalent to target label.Otherwise, substitute with missing values.Counting single letters.Using the spacesas separators to enlist all elements.Reveal all elements.Rule-basedRow Filter ReferenceRow Filter GroupBy Table Creator Column Expressions(legacy) Missing Value Table Creator GroupBy String Replacer Cell Splitter Rule-basedRow Filter Ungroup Column Expressions(legacy) Column Expressions(legacy) Cell Splitter Ungroup NO LOOP APPROACH - THE CODING ROUTE NO LOOP APPROACH - SUBSTITUTION ROUTE Selecting the ones that matchour predetermined criteria.ResultsRevealinginformation onthe new groups.InputScoring SystemBy default, each row getsan accumulative score of 1as we move from one row to another.The scoring pauseseverytime a row's value becomes a duplicateof its previous row of the same group, oreverytime we hop from one group to a different one.Using the scoresto form new groups. (If the first row has a missing value,it does not affect resultsif it remains missing).InputCombining all rowsfor each groupSubstitutingthe single letters withspace.Using the missing valuesas separators to enlist all elements.Remove rowsaccording to our predetermined rule(s).Reveal all elements.SubstituteColumn 2 with Column 3+any single letterwhen the row is equivalent to target label.Otherwise, substitute with missing values.Counting single letters.Using the spacesas separators to enlist all elements.Reveal all elements.Rule-basedRow Filter ReferenceRow Filter GroupBy Table Creator Column Expressions(legacy) Missing Value Table Creator GroupBy String Replacer Cell Splitter Rule-basedRow Filter Ungroup Column Expressions(legacy) Column Expressions(legacy) Cell Splitter Ungroup

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: USER
Created at: 2025-02-14
On NodePit since: 2025-02-16
Last update: 2025-04-01
Created with KNIME version: v5.4.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!