Hi everyone,

I would like to do some settling of an amount based on an id. As an example the following image is supposed to explain my problem:

There is a table with ids, an amount to be paid and a paid amount. I would like to iterate through each id and fill the rows with the settled amount of each position.

So e.g. for id=1 there are 60 paid which have to be split to all rows with id=1, the first row has an amount of 40, so the 60 are completely settling this amount, and there will be 20 left. The left over 20 should be carried on to the next row where 30 are open to be paid. So the 20 are settling a part of the open amount of this position.

Is there any way to solve this issue in KNIME?

Best regards

Marvin