Icon

83454 - Conditionally Distribute Rows

ChallengeCalculate the difference of the 1st row to thefollowing to identify groups based on next rowwith diff >=5Corresponding Forum Posthttps://forum.knime.com/t/split-tables-depending-on-value-differences-in-columns/83454 ValueascendingTopNext RowRemoveDiffTOPDiff >=5TOP1st RowRe-Addnon-matchingResultsValueascendingAdd matching Rowto start with in nextIterationTable Creator RecursiveLoop Start Math Formula Sorter Row Splitter Table Rowto Variable Concatenate Recursive Loop End Column Filter DuplicateRow Filter Math Formula Row Splitter Row Splitter Concatenate Sorter Concatenate Column Expressions ChallengeCalculate the difference of the 1st row to thefollowing to identify groups based on next rowwith diff >=5Corresponding Forum Posthttps://forum.knime.com/t/split-tables-depending-on-value-differences-in-columns/83454 ValueascendingTopNext RowRemoveDiffTOPDiff >=5TOP1st RowRe-Addnon-matchingResultsValueascendingAdd matching Rowto start with in nextIterationTable Creator RecursiveLoop Start Math Formula Sorter Row Splitter Table Rowto Variable Concatenate Recursive Loop End Column Filter DuplicateRow Filter Math Formula Row Splitter Row Splitter Concatenate Sorter Concatenate Column Expressions

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: Mike Wiegand
Created at: 2024-09-24
On NodePit since: 2024-09-25
Last update: 2025-03-31
Created with KNIME version: v5.3.2

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

Try NodePit Runner!