Dynamic Formula Evaluation

Hi Everyone,

I am new to the community and Alteryx. This is an awesome tool and community. I am not sure if this has been discussed before and my searches have come up empty, hence the post in the new ideas section.

I am looking for a way of evaluating formulae that are contained in a database field, i.e. the formula needs to be applied at runtime, but not hardcoded, rather retrieved from a table and then applied to another field/s during the execution run.

Excited to hear any suggestions, support or feedback for this idea.

Kind Regards

Craig

Common Use Cases

Accepted answers

CraigG

Hi,

I have actually managed to do my requirement using the existing Dynamic Replace tool with expressions. Works very well.

Kind Regards

Craig

All comments

MarqueeCrew

@CraigG,

Get ready for Awesome! @AdamR_AYX is way ahead of you. Within the CReW macros lives the "Dynamic Formula" tool. I've written a blog post about it, extolling the virtues of it. The tool asks you four (4) questions and will then compute not one, but many (no limit) new variables. Essentially, if you feed it a list of variables to calculate it will read the library of formulas and create each desired new element. The four questions are: