Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Substitute Multiple Cells in Batch Macro


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.




and then on your action overwrite the word placeholder.


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




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.