Quantity Mix&Match on Inventory and Order

[ElwinPang]

Hi Expert, good day. Need all of your help on resolving the problem below: ~

I have 2 input sources here: ~

Input 1 - Inventory
ID	PP_ID	Group	Qty
1	B-253-ZRLQCL	A	3
2	B-958-49WHDD	B	3
3	B-614-M95QKX	C	1
4	B-253-ZRLQCL	A	2
5	B-614-M95QKX	C	5
6	B-253-ZRLQCL	A	1

Input 2 - Order
PO	PP_ID	Qty
XX1	B-253-ZRLQCL	3
XX2	B-958-49WHDD	2
XX3	B-253-ZRLQCL	3
XX4	B-614-M95QKX	2
XX5	B-614-M95QKX	3
XX6	B-958-49WHDD	1

So what i trying to achieve is to mix and match between input 1 and input 2 to have the following output: ~

	Output
ID	PP_ID	Group	Qty	PO	PP_ID	Qty
1	B-253-ZRLQCL	A	3	XX1	B-253-ZRLQCL	3
4	B-253-ZRLQCL	A	2	XX3	B-253-ZRLQCL	2
6	B-253-ZRLQCL	A	1	XX3	B-253-ZRLQCL	1
2	B-958-49WHDD	B	2	XX2	B-958-49WHDD	2
2	B-958-49WHDD	B	1	XX6	B-958-49WHDD	1
3	B-614-M95QKX	C	1	XX4	B-614-M95QKX	1
5	B-614-M95QKX	C	3	XX5	B-614-M95QKX	3

Plus 2 summaries, input 1 not matched/ excess and Input 2 not matched/ partially matched

Please help, thank you very much in advance. 

[atcodedog05]

Hi @ElwinPang 

Here is a workflow for the task.

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[ElwinPang]

Hi, thanks for the reply. But the workflow didn't produce what is shown in the output table. 
First, it need to find the exact match without repeated input 1 and 2. 
Secondly, those not able to join perfectly; need to try and match them up and those not able to match will give a summary like "Plus 2 summaries, input 1 not matched/ excess and Input 2 not matched/ partially matched"

[atcodedog05 · Accepted solution]

Hi @ElwinPang 

Inventory stock management is not always easy.

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍