finding partial matches in two lists

[lyderic]

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.

[BS_THE_ANALYST]

@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-... 

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

[lyderic]

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