Loop in Loop

[Alteryx_user_aK]

Hi,

I have a bit complex requirement to solve using Alteryx.

I have one table which has items and stock availability like below

Item           Available stock for a day

ABC          100

BCD          400

PQR          800

OPQ          200

I have another table which is sorted by priority and provide require quantity. (Note: Final Items consists of Items)

Final Item     Item    demand 

abc              ABC       50

                   OPQ       50

                   BCD       100

xyz              PQR       200

                   ABC       200

                  OPQ       100

                  BCD       300

tuv              ABC       500

                  OPQ        50

What I want to product is (it as per the items not final item)

xyz  ABC   200 (50 ABCs given to abc. only 50 left but demand is 200)

tuv   BCD  500

All other items's need is under the stock hence they should be ignored.

 Thanks

aK