Dear KNIMErs, I can’t wrap my head around how to solve this little problem: I have the following table: [image] 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: [image] Loop on Condition – rs1 This workflow implements a loop cycle on condition, that is a loop that stops when a given condition is met. It is a game. I think of a number and write it int… 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). [image] Loop aggregate based on condition – kowisoft Solutions for data science: find workflows, nodes and components, and collaborate in spaces. Can anyone nudge me in the right direction?

Loop and aggregate values until a certain condition is met

mlauber71 August 13, 2024, 10:50am 5

@kowisoft without having looked deeply into it you will have to collect what is happening and store the intermediate values. I constructed this example but there is also the recursive loop that can somehow do that automatically but I am not that comfortable with.

Question is do you want some sort of optimization where you would try to come as close to the 100k as possible with your values.

1 Like