Fuzzy Matching

[goatley1]

Does anyone else bang their head against the wall with fuzzy matching?  The way Alteryx manages this with the creation of record IDs and unions is maddening.  

Is there another way to do this.  The logical way is with a cartesian product of your two sources, and then a formula.  That's 2 steps.  The only thing missing is the formula.  Instead we get a mish mash of needlessly created fields and harmonization, only to join the data back to it's original data sets.  Then you still don't have a single data set with the matches.  So frustrating.

[alexnajm]

I would say it's the best way - this Tool Mastery article reflects what you are saying, and I have used it successfully across a few use cases: Tool Mastery | Fuzzy Match correspondance partielle fuzzyübereinstimmung (alteryx.com)

[ChrisTX]

This post includes a sample fuzzy match workflow "Fuzzy Match.yxmd":

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Comparing-Data-sets-with-slight-differ...