Alteryx and Boolean
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Labels:
- Expression
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
this saved me , thanks man.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
the '=1' part of this is just redundant. if you have a boolean field you can have it standalone as the boolean field so
[field1]=True
iif([field1],'True','false')
is sufficient.