How To Create Dynamic Formula in Formula Tool

[lbjohn]

Hello,

Using the attached Excel screenshot. I want Alteryx to dynamically update the operator in the formula tool, depending on the Operator field.

Any idea how I can do this?

Thanks,

John Wong

[DavidP · Accepted solution]

Hi @lbjohn 

I would do this with a batch macro as shown below. Basically, you alter the formula in the formula tool using the desired operator. Pay attention tp how the Action tool in the macro is configured and also how the Group by function is used in the workflow that calls the macro.

Sample workflow attached.

workflow:

Macro:

Action tool configuration:

Using Group by in workflow:

[lbjohn]

Thanks!  I started with the same approach by using Batch macros.   I missed the step of passing the Operator field to the "Question:  Choose Field: Control Parameter"

[apathetichell]

you can also use dynamic replace for this. dynamic replace really should be called dynamic formula.

[lbjohn]

Can you provide a solution using Dynamic Replace.    The built-in Alteryx Dynamic Replace example is not very useful.