Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
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
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
view community events calendar
designer new user guide
Labels