Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hi,
I am looking to use Fuzzy Match on a lookup Field. For example, I have a column with RAW ID codes which I need to map to a master Lookup and create a new column.
Eg :
Is it possible to fuzzy match against the RAW and the LOOKUP field and create a new FINALCODE column?
I've attached the xlsx of the test data if anyone would like to provide a basic workflow.
Many thanks for any help!
Solved! Go to Solution.
Hi @fiorano,
Not sure if it's a use case for fuzzy matching. If my assumption is correct, you're trying to identify if the exact string of characters in your lookup column exist in your RAW field. The reason why I don't think FM is needed is because you need it to find EXACTLY that string.
The "Find Replace" tool (Join tool category) would seem to be the more appropriate tool to use.
I have the tool configured to look for the "Find Value" in any part of the RAW field. If found, it'll append the "lookup" value instead of replacing.
Hope this helps!
Jimmy
Yes, this is where FM may come into play. However, I'm not sure how effective your matches will be since ID codes aren't really grammatical values, which is what this tool is designed to assist with. Using the sample data set you provided, it seems like it would work, but you'd have to thoroughly validate the results when it's ran against your entire table.
It's first using the find replace tool to find the matches and then filtering to split out the records that did not get matched which would be the subset of records that would run through the FM tool.
If you aren't familiar on how to use the FM tool, I'd strongly suggest looking at the KB and the trainings available in the "Academy" section. Unlike most of the other tools, FM will require a lot of trial and error to configure the tool to generate matches within your acceptable threshold range.
