Idea Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Notify Moderator
Switch formula should support more than "=" condition or give error
Status:
Accepting Votes
Submitted by
marco_zara
on
‎02-08-2023
07:27 AM
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Notify Moderator
Actually not sure if to flag it as feature request or bug.
As per Conditional Functions | Alteryx Help the Switch function only works with "=" cases.
Trouble is, a typical case function might be a variant of different if [x]<[y] then "a" in a similar way to the "manual" setting of the tile tool.
If used in that way, the switch function will happily run but return wrong results, as it happened to me in a recent customer training session.
IMHO either the switch function should support everything an IF does or throw an error when it doesn't and the documentation should be updated.
What do you think?
See more ideas labeled with:
1 Comment
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
