Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Quantity Mix&Match on Inventory and Order

ElwinPang
8 - Asteroid

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

 

I have 2 input sources here: ~

Input 1 - Inventory
IDPP_IDGroupQty
1B-253-ZRLQCLA3
2B-958-49WHDDB3
3B-614-M95QKXC1
4B-253-ZRLQCLA2
5B-614-M95QKXC5
6B-253-ZRLQCLA1

 

Input 2 - Order
POPP_IDQty
XX1B-253-ZRLQCL3
XX2B-958-49WHDD2
XX3B-253-ZRLQCL3
XX4B-614-M95QKX2
XX5B-614-M95QKX3
XX6B-958-49WHDD1

 

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

 Output
IDPP_IDGroupQtyPOPP_IDQty
1B-253-ZRLQCLA3XX1B-253-ZRLQCL3
4B-253-ZRLQCLA2XX3B-253-ZRLQCL2
6B-253-ZRLQCLA1XX3B-253-ZRLQCL1
2B-958-49WHDDB2XX2B-958-49WHDD2
2B-958-49WHDDB1XX6B-958-49WHDD1
3B-614-M95QKXC1XX4B-614-M95QKX1
5B-614-M95QKXC3XX5B-614-M95QKX3

 

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

Please help, thank you very much in advance. 
3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @ElwinPang 

 

Here is a workflow for the task.

Workflow:

atcodedog05_0-1605603085125.png

 

Hope this helps 🙂


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

ElwinPang
8 - Asteroid

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
22 - Nova
22 - Nova

Hi @ElwinPang 

 

Inventory stock management is not always easy.

 

Here is a workflow for the task.

Output:

atcodedog05_0-1605606351695.png

Workflow:

atcodedog05_1-1605606378238.png

 

Hope this helps 🙂


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

Labels