Automatic generation of formulas whit Alteryx

[JSABOGAL]

Good afternoon, I would like to know if there is a process by which I could automatically load a file with formulas in Alteryx, update me and create the respective fields within the function. The idea is that it automatically updates and creates n number of fields according to a data input as defined in the formulas file.

[apathetichell]

if you have a limited number of possibilities (ie it will always be two fields) and a limited number of mathematical operators (ie +,-) you could set this up with three drop downs - two for the fields and one for the numeric operator. Moderately complex.

[TheOC]

hey @JSABOGAL 
Technically, anything is possible. You could have this as a batch macro/iterative macro, and run each formula separately. This would allow for an unlimited number of formulas to be passed in. 

It might be tricky to setup however - i'd recommend starting by learning iterative macros:
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Iterative-Macr...

It may also be worth thinking about if there is another angle to attack your problem from. 

Hope this helps,
TheOC

[MarqueeCrew · Accepted solution]

Thank you @TheOC for helping me to make a quick challenge solving video.  The video is processing now ....

[video]

Cheers,

Mark

[JSABOGAL]

Thank you very much for the help and participation of the entire team of this community.

[JSABOGAL]

Thank you very much !!