Inventory of each dish

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?

The quantity.xlsx

Products.xlsx

Accepted answers

Kenda

@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.yxzp

All comments

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?

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703