I have tried 2 approaches to get Alteryx to treat a Field as boolean:
1) Data is either 'TRUE' or 'FALSE' and I use a SELECT tool to set datatype as Boolean
2) Data is either 0 or 1 and I use SELECT tool to set datatype as Boolean
Expressions don't seem to work consistently however.
Can someone explain best practice to get the data to be recognized as Boolean and some simple IIF() expressions to resolve a true or false?
The boolean values are displayed as True/False, but when you deal with then using formulas, you will need to always use 1 for True and 0 for False. Dont use 'True' or 'False' inside your formulas.