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
W.
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
Solved! Go to Solution.
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.
Hi Datanath,
Thanks so much! This looks like it is definitely what I am looking for.
I will play around with the WorkFlow but this looks great. Many thanks on this!
Mike
Hi ArtApa,
Thanks for pointing me towards the Find Replace Tool and for taking the time to answer my post. Much appreciated!
Thanks again!
Mike