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.
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.
