Fuzzy Match - Merge Help

[yalteryx]

Hi all, trying to match an identifier field that contains letters & numbers between 2 different sources. 

• Join tool:  I have the L and R unioned together from 2 sources
• I have created a a new formula field for each L and R to identify sources
• assigned a unique record for each item

For example: In below sample, I want

record 11 for Security 1234MJ4R8 in Source 1 to match record 45 Security US1234MJ4R86 in Source 2

Sample data below:

RecordID	SECURITY	Account	Source
1	BR3FN0055216	D	2
2	BR0000075681	A	2
3	BR3FN0054805	A	2
4	BR3FN0055216	A	2
5	YZ12499457	A	2
6	YZ12499457	A	2
7	BR2CLT231003	B	2
8	BR3FN0054813	B	2
9	BR3FN0055216	B	2
10	161175BK9	C	1
11	1234MJ4R8	C	1
12	1234MJ4W7	C	1
13	1234MJ5S5	C	1
14	1234MJ5T3	C	1
15	1234MJ6B1	C	1
16	1234MJ6C9	C	1
17	1234MJYU8	C	1
18	3132VN2F9	C	1
19	3132Y0M98	C	1
20	3140F2V23	C	1
21	3140H1DJ6	C	1
22	31418C3D4	C	1
23	31418CDL5	C	1
24	31418CXM1	C	1
25	98769QGC9	C	1
26	98769SQV2	C	1
27	98769T4Q5	C	1
28	98769T7L3	C	1
29	98769TAL9	C	1
30	98769TNS0	C	1
31	98769TSG1	C	1
32	98769TV44	C	1
33	98769TZ65	C	1
34	98769USS2	C	1
35	US01F0204713	C	2
36	US01F0204895	C	2
37	US01F0206791	C	2
38	US01F0206874	C	2
39	US01F0224778	C	2
40	US01F0226757	C	2
41	US01F0226831	C	2
42	US01F0306781	C	2
43	US161175BK95	C	2
44	US21H0226710	C	2
45	US1234MJ4R86	C	2
46	US1234MJ4W71	C	2
47	US1234MJ4Y38	C	2
48	US1234MJ5S50	C	2
49	US1234MJ5T34	C	2
50	US1234MJ6B17	C	2

I am having trouble matching them still with my below configuration: What Custom Match Style would apply for this scenario?

Thanks!

[fmvizcaino · Accepted solution]

Hi @yalteryx ,

The problem with the fuzzy match is related to the maximum key length, Alteryx will only start fuzzy matching if the first letter (defined below as 1) is equal in both datasets. I created an example using fuzzy match but also using find/replace - in case your smaller security keys are contained in the bigger one.

Best,

Fernando Vizcaino