1. I would use a Fuzzy Match tool
2. Configure it to use the Merge option and use a source ID field from an Excel table where you have the standardized names
2.1 To do this you have to union your data with the standardized source data (the Excel table with standardized names)
2.2 Use a formula tool to identify the source table (Excel table with standardized names) and your data. This can be done before or after joining the tables (using the union tool). I'm going to explain by doing this before
a. Create a field in both files named "source". In your data, under the newly created "source" field add the expression "Data". In your Standardized names file, under the newly created "source" field add the expression "Standard"
b. Union both files
2.3 In the fuzzy match configuration window, under Source ID field, choose your Standard names in your Standardized names file as the source.
2.4 In the fuzzy match configuration window, under Record ID field, choose your Business name by region field in your data file.
2.5 In the fuzzy match configuration window, under Match fields, specify the field name you need to have standardized/renamed. In this case it is your business name by region field as well. Under Match Style you can select "Name".
***Use the "Match Threshold" up and down arrows to specify how close of a match you want. I think it's set at 80% by default (you can play with this until you get your desired result)***
3. Run the workflow. It will output 2 columns/fields, one with the original Business name by region field and one with the Standardized Business name by region.
4. You can use the output in Step 3 as a mapping for your original data using a Find Replace tool.
This will automate and standardize your fields should new business names by region show up in the future.
Here is a link to an article in the Alteryx community to help with setting this up until Step 3 above.
Prepare two inputs for Fuzzy Match Merge Mode
Enjoy!
