Icon

Stop loop on condition combined solution

create valuetablecreate threholdvalue tablecreate flow variabletotalValuewrite"below"COL_SUM($values$)turn currentValueinto flow variableKeep rows from0 to currentIerationFinish loop whencurrentValue >= totalValueget RowIDsin new columndelete everything after "#"write RoWIDsbackremovehelper columnsjoin with rest (unexecutedin loop) part of tableoverwritevalues columnwritetemp tableread temp table againTable Creator Table Creator Table Rowto Variable ConstantValue Column Math Formula Table Rowto Variable Row Filter Variable ConditionLoop End Generic Loop Start RowID String Manipulation RowID Column Filter Joiner Rule Engine Table Writer Table Reader create valuetablecreate threholdvalue tablecreate flow variabletotalValuewrite"below"COL_SUM($values$)turn currentValueinto flow variableKeep rows from0 to currentIerationFinish loop whencurrentValue >= totalValueget RowIDsin new columndelete everything after "#"write RoWIDsbackremovehelper columnsjoin with rest (unexecutedin loop) part of tableoverwritevalues columnwritetemp tableread temp table againTable Creator Table Creator Table Rowto Variable ConstantValue Column Math Formula Table Rowto Variable Row Filter Variable ConditionLoop End Generic Loop Start RowID String Manipulation RowID Column Filter Joiner Rule Engine Table Writer Table 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: Loic
Created at: 2022-06-29
On NodePit since: 2022-10-23
Last update: 2024-11-21
Created with KNIME version: v4.6.3

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

Try NodePit Runner!