Inventory of each dish

[Feras95p]

Dear all,

I have attached two excel files, The quantity and Products files.

In the quantity file I have two columns SKU and quantity. Whereas in the Products file I have the explanation of SKU. So that each SKU present the quantity of each dish sold.

What I'm looking for is that I want to have the total number sold of each dish in the product file.

So any help in that please? 

[Kenda]

Hey @Feras95p 

Can you use a Join tool and join on the SKU field?

[Feras95p]

After using the join tool what I can do? Do you understand what I'm trying to reach?

[Kenda]

@Feras95p  I don't think so... Could you provide a sample of what you're wanting your output to look like based on those two inputs?

[Feras95p]

@Kenda  Ok I will provide for you example, let's say that in the quantity file we have only two SKU which are the highlighted yellow ones 

so from these will go to check in the products file 

And the output should be like this

Note that sometimes the quantity will be more than one so it should multiply by the quantity number.

Hope now it's clear for you.

[Kenda]

@Feras95p 

Try the attached workflow to see if it gets you what you're looking for. Reach out with any additional questions. 

[Feras95p]

No, still what I'm looking for not clear for you, I want to have only the total number of sold of each dish as shown here in the example provided for you.

Your workflow given different output. If you can follow my example will be more clear for you 

[Kenda · Accepted solution]

@Feras95p 

I tweaked the workflow a little bit. Is this what you are looking for? If not, are you able to follow the logic and help me figure out where our disconnect is?

[Feras95p]

Your first workflow the output from the join function  is that,

Which is great! I need only to add the highlighted green one. So, it's multiply  the quantity by the dish  and write the value as shown in the example I made. At the end I need each dish with the total number as shown in the previous example. Hope that's cleat now

[Kenda]

So is this the final output you're expecting based on the two files you posted earlier? @Feras95p 

Dish 1	Dish 2	Dish 3	Dish 4	Dish 5	Dish 6
162	164	118	115	198	54