topic compare and update a stock value in Talend Studio

compare and update a stock value

pawe84 — Sat, 16 Nov 2024 02:48:09 GMT

Hi everyone,

I have this table view (see also attached file, sheet "table_view").

The problem now: I have to compare for each product and customer the current stock value and if the requested quantity or less could be delivered.

E.g.: Product = Monitors; the whole product has only a stock value of 150.
The first customer requested 100, so we are able to deliver 100
after that -> 150-100=50. The 2nd customer wants 75 but now we can only deliver 50 and the 3rd won't get anything because stock is empty now.

The output column should look like this (qty_available).

How to compare stock values?

Thanks for any information.

Re: compare and update a stock value

manodwhb — Fri, 03 Apr 2020 09:39:56 GMT

You can do this with tmap by using variables.

Re: compare and update a stock value

pawe84 — Mon, 06 Apr 2020 15:30:43 GMT

But how to create dynamic variable if you have thousands of products?

Do I have to count my products at first and then I would get the number for my variables?

If this is the data view for each product at first we have to find the current stock value because it's a 1:n join

like this example below.