Identifying entries that *could* be fixed by fuzzy match
Our take
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Fuzzy Lookup Question- Finding exact matches and fuzzy matchesI have two tables. Table 1 contains the columns Account_Name, ID #, and Address1 and Table 2 contains the columns Name2 and Address2. I want to perform a fuzzy match on the Name columns BUT only if there is an exact match on the corresponding Address columns. Is this possible with the fuzzy match excel add-on, and if so, how is it performed? I have found that the existing configurations do not work to perform a fuzzy match and an exact match at the same time, but has anyone had any luck with this? Thanks in advance!! submitted by /u/amoretzamarro [link] [comments]
- Replacing data with power queryi am doing a scrub matching file from data pulled from my company CRM. as you may know most of the information here (company names) are not static. i CANT use fuzzy matching because it makes it worse. so i am trying to make a static list. my list is a 100% accurate i tried myself with xlookup and checking UNIQUES names are all written in the exact same way in the static list, even manually went through some of the examples the problem? while merging the queries tho the names are there the way its on the data and its static version to replace, power query is not detecting some of them. like yeah its working for the 30% of the inputs but the other 70% are appearing as null/blanks. so my theory is correct but why is it not applying to all of them values? english is not my first language so apologies in advance if its hard to understand. i dont want to make this long but i can also further explain step by step how i am doing it. thank you submitted by /u/DifferentMeat9240 [link] [comments]