Normalize vendor/supplier names

[lindbergh]

I have a list of vendor/supplier names with different variations. For example, I will have 75 records with Amazon Web Services and 25 records with AWS as names for Amazon Web Services. What I want to do is name all the records with AWS, as Amazon Web Services.

I tried to create a join and union but that did not seem to return the 100 records.

How would I be able to normalize the names?

Thanks

[jdunkerley79 · Accepted solution]

I would suggest using a Find and Replace tool. You can give it a list of things to map to Amazon Web Services.

Demo workflow attached.

[lindbergh]

That worked. Thanks