finding partial matches in two lists

Question

hi,

I have a list of product from one company and another one from another company. I'd like to find products that may be the same across the two companies. Because the spelling of the products may differ between the two companies, I'd like to do a fuzzy match. Could someone help me set it up?

See example below.

lyderic · Answer

Hi, thank you for your reply. I spent some time reviewing the examples. But I still can't make it work...

BS_THE_ANALYST · Answer

@lyderic as with most things in Alteryx, check the tool's examples. It provides a good baseline for understanding the kinks:

Also: Fuzzy Match FAQ: https://help.alteryx.com/current/en/designer/tools/join/fuzzy-match-tool/fuzzy-match-faq.html#fuzzy-match-faq

and the tool's help page: https://help.alteryx.com/current/en/designer/tools/join/fuzzy-match-tool.html#fuzzy-match-tool

All the best,

BS