Hi all, trying to match an identifier field that contains letters & numbers between 2 different sources.
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!
Solved! Go to 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