Aggregation in loop
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: