This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi. I am working with data that is input with no standardization. I have no master list for comparison. The same business contact gets input a multitude of ways. For example: on attorney contacts, I might get XYZ Law PLCC, XYZ Attorneys at Law, the Law Offices of XY & Z, XY Law Firm, etc. I am trying to use the fuzzy match tool to clean up this data for reporting. I have some comparable information, like addresses and phone numbers, but some businesses have multiple locations.
I have watched the sessions on fuzzy match usage and searched the community, and still cannot seem to get this to work property. Ideally, I want to have a resulting spreadsheet that just shows the original data with an additional column at the end with the grouping name that is most commonly found from the fuzzy match workflow, which I can then use to pivot data in reports.
I have attached what I have tried to build so far. Any help would be greatly appreciated!