Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Normalize vendor/supplier names

lindbergh
7 - Meteor

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

2 REPLIES 2
jdunkerley79
ACE Emeritus
ACE Emeritus

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
7 - Meteor

That worked. Thanks

Labels