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

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.

 

 

2 REPLIES 2
wonka1234
10 - Fireball

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

 

CoG
14 - Magnetar

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

Screenshot.png

Labels
Top Solution Authors