How to discount in the same column?

[GOLTLC]

Hi guys!
I’m new at Knime and I am trying to perform a subtraction in order to consume my available stock.

In this scenario, I have multiple clients that want the same SKU, but I can’t fulfill all the requests. For example, the client X wants 5 pieces of SKU A, and since I have 20 pieces available, I can fulfill his request and still remain more 15 pieces. My second client, Y, wants 15 pieces from the same SKU, and I can fulfill his request, remaining zero pieces.
Since I have another client (client Z) that wants more 2 pieces, I will not be able to deliver his request, because I do not have a single piece left.

I don’t know how to do this math in knime. Can anyone help me please?

[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.