This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
Get ready for Awesome! @AdamR 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:
Output Field - Where in the list is the desired name of the new field?
Type - Where in the list is the data type for the new field?
Size - What is the size of the new field?
Expression - What is the expression/formula to define the new field?
If the fields build upon each other, you will need to make sure that they are in the proper sequence. This is a magical tool.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.