Aggregation in loop

KNIME Analytics Platform
1

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 :slight_smile:

2

@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:

image
image1921×924 130 KB

4 Likes