Substitute Multiple Cells in Batch Macro

[bchan07]

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.

[BenMoss · Accepted solution]

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

[bchan07]

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.