Fuzzy Match - Easy or Hard?

[JohnJPS]

Spoiler: I've attached the solution workflow to the On Demand Intermediate Fuzzy Matching.  I've modified this to add an alternate solution; color coded for ease of reading. Both solutions are sorted prior to "browse tool," to make comparison easier.  

The Calgary file already has a fuzzy match key, and the "Input" also generates the fuzzy match key for us. We need only join these together and we're done: in the end, the resulting output from the alternate solution is virtually identical to the output from the much-more-complex provided solution.  So the question is - what am I missing?  Why all the complexity in the provided solution?

[PatrickN]

Thanks for catching this.  The data files and the solution are incorrect as there should actually be about 46 possible matches.  We will update the files on the Self-Paced training web site.  As soon as the files are updated, I'll let you know.

[PatrickN · Accepted solution]

A new Fuzzy Matching exercise has been posted in the Intermediate Self-Paced exercises.  Thank you for catching the error.

[JohnJPS]

Thanks - I can definitely spot where and how the solution is giving more useful (and different) results, compared to my simpler (and possibly too simplistic) "generate keys-then-join-on-keys" approach.