SOLVED
Compare 2 columns from same dataset (Not Exact Match) Fuzzy Match?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
wonka1234
10 - Fireball
‎11-29-2023
07:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying to compare columns NUM and Number. Does nto need to be EXACT match, but i want it to find strings that could be similar.
Expected output
Name | Cust_No | ID | NUM | Right_Name | Right_Cust_No | Nmmber |
Louis | 55555 | License | 56575 | Louis | 55555 | 6575 |
Louis | 55555 | Passport | US12345 | Louis | 55555 | US123 |
Louis | 55555 | License | 1234 | Louis | 55555 | 1234 |
Louis | 55555 | Passport | CA12345 | Louis | 55555 | 1234 |
Louis | 55555 | Passport | US12345 | Louis | 55555 | 1234 |
please see attached workbook.
Solved! Go to Solution.
Labels:
- Labels:
- Custom Tools
2 REPLIES 2
‎11-29-2023
08:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
CoG
14 - Magnetar
‎11-29-2023
09:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator