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.

Substitute Multiple Cell.PNG

BenMoss

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