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.
I'm working with a dataset that includes entities, their utilization amounts and corresponding date.
Some of the entity names are formatted differently.
Entity Utilization Amount Date
A, INC. 300 5/13/2007
A INC. 500 6/20/2009
A INC 700 12/23/2019
I want to keep all of the entries and am curious if there's a way to use Fuzzy Match to ensure that the workflow knows that all three of those entities listed are equivalent.
For instance, I might want to pull all of the utilization amounts for the given entity above in a spreadsheet that includes the output, but then if I try to filter in Excel, I would have to manually select "A, INC", "A INC.", and "A."
Is there a way to avoid this, so that the workflow matches
"A, INC." = "A INC." = "A INC"?
Perhaps I need to ignore the commas and the periods? If anyone has ideas on how to approach this, I would really appreciate it! Many thanks in advance.