Loop and aggregate values until a certain condition is met
Dear KNIMErs,
I can’t wrap my head around how to solve this little problem:
I have the following table:
What I basically want to do is to loop through these line items and stop, when a certain condition is met.
The condition is this
IF item supplier X’s total value exceeds 100,000
I considered a loop and doing a Variable Condition Loop End Node, following the approach that @rs1 described in this workflow on the Community Hub:
However, I can’t get the inner part of the loop to be working. I already played around with the GroupBy Node as well as the Moving Aggregator Node but they do not help me inside the loop (or I use them the wrong way, which is probably more realistic :smile: )
I have provided a (pretty basic) example workflow where I also have a Double Widget Node to interactively set the threshold value (the 100,000 from the IF statement above).
Can anyone nudge me in the right direction?