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