Log In
Register
Home
August 4, 2020
Offline
I'm pulling data into a query from a webpage and attempting to merge it with an existing table in order to add a "foreign_Key" column.
The issue i'm having is that sometimes different names are used in the column I use to merge the tables and this results in a null result.
An example of this is that the name from the webpage can sometimes be "Alberts" or "Alberts Park" and in my table it is listed as "Alberts Park" so when the merge compares the two columns I get a null result for those that are just "Alberts".
Is there a way around this? The only way I can see of fixing it is to have duplicated entries in the key table with the different name variations.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Richard,
There is a fuzzy merge option in PQ, expand the advanced Merge options (hope your version has these options)
You can add the match percentage and other fuzzy match options.
However, a fuzzy merge will never be perfect, there may be wrong results.
1 Guest(s)
