The New Fuzzy Matching Feature in Excel’s Power Query

/in /by

There’s a new feature in Excel’s Power Query and it’s the Fuzzy Matching features in the Merge/Joins wizard.

Fuzzy Matching or Fuzzy Merging are when you have to match things like:

Jen and Jenny
Rob and Robert
Rick T. Burns and Rick Burns

These won’t match at all via regular joins. But the user has to be careful with the Fuzzy Matching because it’s based on a percentage of similarity. Check out the video. You’ll see.

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2