community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Compare 2 columns from same dataset (Not Exact Match) Fuzzy Match?

wonka1234
10 - Fireball
‎11-29-2023 07:56 AM

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 

 

NameCust_NoIDNUMRight_NameRight_Cust_NoNmmber
Louis55555License56575Louis555556575
Louis55555PassportUS12345Louis55555US123
Louis55555License1234Louis555551234
Louis55555PassportCA12345Louis555551234
Louis55555PassportUS12345Louis55555

1234

 

please see attached workbook.

 

 

fuzzymatchhelp.yxzp
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
wonka1234
10 - Fireball
‎11-29-2023 08:22 AM

Tried find and replace, but it isnt really giving me great matches.

 

find and replace try.yxzp
Reply
0 Likes
CoG
14 - Magnetar
‎11-29-2023 09:50 AM

It looks like you can just use the Contains function in a Filter Tool:

Screenshot.png

fuzzymatch help.yxmd
Reply
Community Live Fifa Workshop
Labels
Top Solution Authors
View All