Identifying entries that *could* be fixed by fuzzy match
Is there any way to pull a list of entries that would, in fact, be fixed by a fuzzy match without relying on the fuzzy match itself (data still needs to be manually reviewed at the end of the day) . Best I can think of is running the fuzzy match itself in power query and then adding a column that checks if the result is the same as the original input data but I have to imagine there’s a better way to do it (and it’s a comparison between 8 separate tables which is my secondary question lol)
TLDR trying to find the best way to identify entries that are close, but not quite the same across multiple tables. We’re talking stocks, so META vs META US for Facebook as an example of the data inputs that should be pinged
[link] [comments]
Want to read more?
Check out the full article on the original site