Forum Discussion
Fuzzy Matching in Power Query Not Working
Hi all, I'm currently trying to do a fuzzy match in Power Query. I have two tables - one that contains a bunch of columns that have customer data in them and specifically a customer name column. ...
Hi NCPowerBI
Go to the table you want to REMOVE the rows from and choose Merge.
Set this to Left ANTI and the number of matches to 1.
Highlight the two columns.
Here you can see I am EXCLUDING 49 rows that exist in the second table but not the first.
This produces a new column but it will be empty, you can just delete or ignore it.