Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Find replace / join tool limitations

Highlighted
8 - Asteroid

Is there any tool to do a find replace data cleanse using a list of word pairs that can be applied to mutiple columns in a single step?

 

Similar to the data cleanse tool but a list of word/character pair values can be applied to multiple columns in your data set?

Highlighted
11 - Bolide

Hi Stephen,

 

There's a couple of ways you could do this.  You could create a Standard Macro to do it, but it might be easier to use a Multi Field Formula instead.

Highlighted
8 - Asteroid

I was hoping someone would have a built a widget for this, seems like a very common use case.

 

20 word pairs along 50 columns would take some time in the formula tool, excel might be actually better for this.

Highlighted
Alteryx Certified Partner

Hi @StephenF You can transpose your data, then find and replace it, and then cross tab it back, like here

 

clipboard_image_0.png

 

Highlighted
11 - Bolide

Here's a really quick and dirty example of how you could do it.

 

You could create a more complicated module that would change more than one Find / Replace pair, but this one works for a single pair.

 

StephenF_query.jpg

Labels