Replicate the Excel “contains” logic in Alteryx

[EmilAlteryx01]

Hi, 

How do i replicate the Excel “contains” logic in Alteryx, where I want the output to only include all items from Input 2 - if the AreaCode from Input 1 (e.g., 81730A108) is contained within the AreaCode_intrl_Number column from Input 2 (contains 11 rows if done manually)

My Designer does not have the "Custom Condition" option in the Join tool

Input 1 - 

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

Input 2

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	770480Z301MNN	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	76425N101XMN	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

[alexnajm · Accepted solution]

Use a Find Replace to match on Any Part of Field and append the column to the data, then use a Filter to only keep the matching rows!

[EmilAlteryx01]

Hi Alex., Thank you so much ..

This Solution worked