Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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