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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.9

The latest release includes several enhancements designed to improve your Community experience!

Learn More
SOLVED

Substitute Multiple Cells in Batch Macro

Highlighted
Atom

Hello, I am writing a macro which requires me to Substitute Multiple Cells. In the screen capture (of part of macro), the key word "LOB" needs to be substitute by the input word, while the rest need to be in place (i.e. LOB_GU replaced to Input1_GU).

 

Can you please suggest easiest way to achieve this in Alteryx ? I tried "Update Value" in action but it doesn't work for me.

Alteryx Certified Partner
Alteryx Certified Partner

You could use a multi-field formula tool and then would only need one action to overwrite the value in that; rather than loads of update value tools.

 

replace([_currentfield_],"LOB","Placeholder")

 

and then on your action overwrite the word placeholder.

 

Let me know if you need more detail on how to implement this.

 

Ben

Atom

thanks and this readily solved my problem. Only difference in my implementation is that I link control parameter to multi-field formula tool directly, action is completely skipped.

Labels