Multiple Find and Replace in the Same Field

Hi there,

I was wondering if it was possible to do a find and replace in my data with Alteryx, looking to replace multiple values in the same field and in the same record.

For example, I have a field in my data called Address and I want to search every record the Address field for the following values;

West

Street

St.

Avenue

Ave

So if I found any of these values in the same field, in the same record, I would want to replace these values with a blank space.

I have done this test in other languages and applications by having a separate list of all the replacement values and I would usually bring in this last as a separate table or as an array, and I would loop through the entire list for the Address field for each record.

Can I build a similar workflow in Alteryx to accomplish the same thing?

Thanks in advance for the help!

Mike

Workflow

Dynamic Processing

Preparation

Accepted answers

DataNath

Hey @mkeiffer, if I'm reading into this right, do you mean something like this?

Address list:

Lookup table with targets and replacements:

Find Replace result:

Depending on your requirement, you may want to play around with the FR configuration i.e. case sensitive, replace multiple items etc, but hope this helps to get you going! To clean up the new whitespace you could also just add a trim step afterwards in a Formula tool.