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.
