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.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hello I would like to match two columns [both location codes] straight across by project number using the Fuzzy Matching tool and output match percentages based on character matched.
I know the fuzzy matching tool is overly complicated and Im wondering if its the right tool or if I can just do it in excel.
Hey @Carlos_Tovar ,
Fuzzy match seems to be the right choice in your case. Unfortunately, we don't have a function inside the formula tool to compare strings, that would be a lot easier to develop.
I've created an example here but I suggest you checking the fuzzy match tool mastery to learn everything about it.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Fuzzy-Match/ta-p/45485
Best,
Fernando Vizcaino
