We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

"Fuzzy Match" between Columns

hubyh
7 - Meteor

Is there a tool similar to Fuzzy Match that enables you to "Match" data between columns on the same row?

3 REPLIES 3
FinnCharlton
13 - Pulsar

Hi @hubyh, there isn't, but using the transpose tool will allow you to move those columns onto different rows, allowing you to use the fuzzy match tool

Felipe_Ribeir0
16 - Nebula

Hi @hubyh 

 

If i understood well what you are trying to do, with some work you can adapt this use case: https://community.alteryx.com/t5/Alteryx-Use-Cases/Fuzzy-Match-Check-Row-by-Row/ta-p/270809

 

Felipe_Ribeir0
16 - Nebula

Hi @hubyh 

 

Check the attached example. You just need to stabilish a value 0-100 that is acceptable as a match. I would use 70.

Untitled.png

Labels
Top Solution Authors