Standardizing Field Values

ryanmor24

Hi all,

So I have a dataset with business names separated by region. For example, ABC - UK, ABC - Romania, DEF - US, DEF Inc. I also have a list of standardized names, for example ABC, DEF. How can I use that list to look through the field values and change them to the standardized names?

Emil_Kos

Hi,

It looks like the find and replace tool will be a place to go. This tool allows us to configure to search fo any part of the field in order to make a match: 

I would also suggest appending this new column just to make sure that you can easily check if this is working correctly:

If you want to read more about this tool please see those two links below:

https://help.alteryx.com/current/designer/find-replace-tool

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Find-Replace/ta-p/47042

Good luck!

Find and replace tool.yxmd