My good friend Gianluca informed me that Microsoft created a new add-in for Excel 2010: Fuzzy Lookup. Fuzzy Lookup was developed by Microsoft Research and was first introduced in SSIS 2005. Now it is available in Excel 2010 as well. It is used for identity mapping and de-duplicating. For approximate string searches, it uses one of the most advanced algorithms currently available. I am already testing it, and works like expected, like SSIS variant: fantastic!
Latest posts by Dejan Sarka (see all)
- Python for SQL Server Specialists Part 4: Python and SQL Server - April 24, 2018
- Python for SQL Server Specialists Part 3: Graphs and Machine Learning - April 11, 2018
- Python for SQL Server Specialists Part 2: Working with Data - March 22, 2018