Source formula from Input file and use it into Formula tool of Alteryx for Calculation

[macvin]

How to source formula from Input file and use it into Formula tool of Alteryx for Calculation

[jrlindem]

Not directly, as far as I'm aware.  You'd have to have the formula come in as a string instead of a function.  Then you'd have to pass that string into something like the python tool to evaluate it then apply it.  I think you can also do something similar using macros but I've not done this myself.

I think the long and short is, it could be possible but it's probably not recommended since it's quite a creative solution that I'm sure is not very flexible.  You're probably better off taking the time to rebuild within your workflow instead.

Best of luck, -Jay

[dreldrel]

If it's coming from an Excel file, you can use a Python tool to read the formulas, and then you put them into your formula tool based on your needs. There are multiple Python libraries that can achieve this. One of the links you can refer to

https://stackoverflow.com/questions/30734294/python-reads-only-the-formula-from-excel-cell

[macvin]

Thanks Jay and Dreldrel for your input. The problem is how to get Formula sourced from other files into Formula tool of Alteryx

[jrlindem]

@macvin - Ya, I hear you.  I think my original note should still be regarded.  Let excel or the source file handle the data, not the logic.  See if you can design your workflow around the logic being housed in the workflow and not managed outside of it.

Sorry we couldn't offer a more concrete path to solving your exact question.  -Jay