Check for Misspellings on Co Name

Hi Centaur ,

 

A few possible options:

 

1) Have a list of properly formed company names and merge it to your table using fuzzy match logic. *NB* This is by no means infallible.

2) Have a list as before, but merge it without fuzzy logic. This will leave blanks in the joined column to identify were misspelling occurs. *NB* This doesn't automatically correct the problem, just quickly identifies where there is a problem.

3) Use the point 2 process to identify misspelling, then apply each different version to a Replace Text step, replacing the incorrect spelling with the correct one. *NB* This can be time-consuming and is entirely reactive, not proactive.

4) Use entry validation in your source. In Excel, this is as easy as only allowing selection of a company from a dropdown populated by a protected list. *NB* If you're not using Excel, you may need to see what similar functions your actual source system can provide.

 

Unfortunately, unless you're using properly defined company ID's and company names, there's no real way for Power Query to know intuitively that Acme should actually be Acme LLC. It can't really make that leap. Fuzzy join logic would be as close as you get to some kind of 'this is similar to...' evaluation, but this comes with its own risks, as I'm sure you can imagine.

 

Pete