community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Tool Mastery | Find Replace

Community Data Engineer
Community Data Engineer
Created on

This article is part of the Tool Mastery Series, a compilation of Knowledge Base contributions to introduce diverse working examples for Designer Tools. Here we’ll delve into uses of the Find Replace Tool on our way to mastering the Alteryx Designer:

  Find Replace.png

The Find Replace Tool is one of those tools that goes relatively unused and uncelebrated until you stumble into a data blending technique that would be extremely difficult without it – at which point, it becomes your favorite tool in the Designer. You can find it in the Join Category and it’ll make easy string substitutions in your data that would otherwise require a herculean effort to work around. Today, we celebrate Find Replace as a hero:

 

hero.gif

                                                              Find Replace to the rescue

 

  • Make effortless HTML or ASCII substitutions (attached in Find Replace.yxzp):

 

HTML Character Replacement.jpg

 

 

  • Use look up tables to standardize data (attached in Find Replace.yxzp):

 

 Find and replace specific targets.PNG

 

 

By now, you should have expert-level proficiency with the Find Replace Tool! If you can think of a use case we left out, feel free to use the comments section below! Consider yourself a Tool Master already? Let us know at community@alteryx.com if you’d like your creative tool uses to be featured in the Tool Mastery Series.

 

Stay tuned with our latest posts every Tool Tuesday by following Alteryx on Twitter! If you want to master all the Designer tools, consider subscribing for email notifications.

Attachments
Comments
Meteor

Your second figure shows the tool configured to replace with the filed Replacement, but this field is not present in the input data shown in the figure.

Asteroid

Hi @deargle, 'Replacement' field is the Text Input 'Lookup Table'.

Cheers!

Atom

Why would the top line of the output not be '11 North Warren Circircle Lisbon Falls.....', as it should pick up the Cir in circle and change it circle?

 

Thanks

 

Lewis

Asteroid

Hi @Lewis,

 

actually, it would be Circlecle haha

 

I think the option 'Match Whole Word Only' was enabled in the configuration when they got those results, but it was disabled when they took the screenshot

 

Peace

 

Ricardo

Meteoroid

does this work to replace a column header? In one of my existing workflows built, one of the columns names was "Department", and the source data has since changed from department to "Business Unit". 

 

Is there a way to rename every instance of the column name "Department" to "Business Unit"?

 

TIA!

 

Meteoroid

You didn't discuss much about the Append part of find & replace