AlteryxFormulaAddOns
AlteryxFormulaAddOns copied to clipboard
Vartext inconsistent behavior in IF statements and conditional assignment
I've attached a file with four different test cases but each of these has some strange inconsistencies with variable setting that seem to evaluate before returning... somehow?
I tried to comment each of them with what was expected.
The cause is the formula parser running. Unfortunately not sure I can determine in parse stage as opposed to run stage.
I have added some new diagnostic functions into the library:
- VarTextExists / VarNumExists - check if a variable is defined
- VarList - writes all variables out as a string in a tab-delimited table
- VarReset - deletes the entire variable set
- Log - allows you to write a log message to a file as part of a formula evaluation
I will attach tweaked versions of your test
Added examples as part of 1.4.0.1 test suite