Aggregation in loop

b_bui · August 30, 2024, 9:24am

Hi everyone,
Can you help to achieve ‘Balance’ using Knime. I tried aggregation method but it after loop it, but it aggregated single column. Is there a choice?

Lag	Plant	Item	Date	Fcst	SOH	Balance
1	X	A	Aug 2024	0	200	200
1	X	A	Sep 2024	5	0	195
1	X	A	Oct 2024	200	0	-5
2	X	A	Aug 2024	5	200	195
2	X	A	Sep 2024	5	0	190
2	X	A	Oct 2024	100	0	90

Thank you

mlauber71 · August 30, 2024, 10:47am

@b_bui firs there are these components by @takbb that can handle cumulative sums for KNIME

Then I edited a recent workflow and came up with this addition solution using recursive loops:

system · November 28, 2024, 10:47am

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.