Join Function Help

[EmilAlteryx01]

I want to perform an Inventory Check using the Join Tool, but my data doesn't match exactly - it is contained within the column. The output should indicate whether I have sufficient inventory, eliminating the need to place an order with the head office.

Daily Input Check -  

Inventory Check Date	Inventory Count	Brand	Account Code	AreaCode
05-May-25	19	Nike	75208111	81730A108
05-May-25	1230	Nike	75208111	76425N101
05-May-25	202	Puma	65632211	70480Z301

Step1 - Area Code Check - I manually do a AreaCode check in excel - with the below AreaCode_intrl_Number - In Excel contains 81730A108 for e.g.,

Step 2 - Account Code - 75208111 should be equal to the Account below with -2 only ; so 752-08111-2 (All accounts with -2 are the only ones required

Step 3 - Qty Check - Inventory Count should be equal to the below QtyPlusCheck exactly (ONLY once Step 1 and 2 are satisfied)

Step 4 - Output - 2 Tabs - Output_Inventory Sufficient - If Step 1,2 and 3 are satisfied ; Output_Inventory Need to Order - if Step 1,2 and 3 are not satisfied

Inventory List - 

Account	AreaCode_intrl_Number	StoreLocation	QtyPlusCheck
752-08111-1	81730A108000	INZ	5587
752-08368-5	81730A108000	INZ	50
798-00081-0	81730A108000	INZ	50
798-00081-1	81730A108000	INZ	60
798-00081-2	81730A108000	INZ	55
798-00081-5	81730A108000	INZ	22
798-00081-5	81730A108000	INZ	30
798-00081-0	95830A108000	INZ	140
752-08368-5	76425N101000	INZ	130
752-08368-2	81730A108000	INZ	30
752-08368-2	72130A108000	INZ	10
753-08368-2	70480Z301000	INZ	5
753-08568-2	70480Z301000	INZ	220
752-08111-2	81730A108000	INZ	19
752-08111-2	81731A108000	INZ	19
752-08111-2	76425N101000	INZ	1230
752-08111-2	81730A108000	INZ	550
752-08111-2	72130A108000	INZ	33
656-32211-2	70480Z301000	INZ	200
752-08111-2	81730A108000	INZ	25
752-08121-5	70480Z301000	INZ	80
752-08121-3	70480Z301000	INZ	100
656-32211-2	80580Z301000	INZ	112
656-32211-1	80580Z301000	INZ	12
686-32211-1	80580Z301000	INZ	44
656-32211-2	70480Z301000	INZ	10
656-32221-2	70480Z301000	INZ	10
897-32221-2	70480Z301000	INZ	10
897-32221-1	70480Z301000	INZ	10
897-32221-0	70480Z301000	INZ	5

[Qiu · Accepted solution]

@EmilAlteryx01 
Since the formatting is different in 2 lists for Account Code AreaCode so I have to assume that they can be unified somehow.
And I use the "Block Unti Done" tool to output the 2 sheets you need.