How to discount in the same column?

[bruno29a]

Hi @GOLTLC and welcome to the Knime Community.

I think this thread is a bit similar to what you are looking for:

Allocate Transactions to a budget

Hi Knime experts, I am trying to allocate a transaction table to a budget table where there are multiple budgets available for one transaction. When a transaction exceeds a budget of a PO, it proceeds to the next PO where funds are available. For example: Table 1 (Budget): |PO|WO|Budget| |PO123456|ABC111|500| |PO246812|ABC111|200| |PO369246|ABC222|100| |PO483692|ABC222|100| |PO548369|ABC333|100| Table 2 (Transactions): |WO|Name|Cost| |ABC111|Matt|300| |ABC111|Candace|150| |ABC111|J…

Please check it out, there are sample code from the Community in the thread that addresses what the user was looking for, which looks similar to what you are looking for.

If this does not work, please let us know, and we will try to come up with something new.