community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Dynamic Formula Evaluation

Meteoroid

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

 

Alteryx Certified Partner
Alteryx Certified Partner

@CraigG,

 

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:

  1. Output Field - Where in the list is the desired name of the new field?
  2. Type - Where in the list is the data type for the new field?
  3. Size - What is the size of the new field?
  4. 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.

 

Cheers,

Mark 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Meteoroid

Hi Mark,

 

Awesome indeed! Thanks for pointing me to that macro. I will be testing it soon to see if this meets my requirement. 

 

Seems magical indeed :-)

 

Kind Regard

Craig

Meteoroid

Hi,

 

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

 

Kind Regards

Craig

Labels