In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Add "BETWEEN" as an operator function

Status: Implemented Submitted by on ‎09-01-2017 06:59 AM
15 Comments (15 New)

This is a pretty quick suggestion:

 

I think that there are a lot of formulas that would be easier to write and maintain if a SQL-style BETWEEN operator was available.

 

Essentially, you could turn this:

ToNumber([Postal Code]) > 1000 AND ToNumber([Postal Code]) < 2500

 

Into this:

ToNumber([Postal Code]) BETWEEN 1000 AND 2500


That way, if you later had to modify the ToNumber([Postal Code]), you only have to maintain it once.  Its both aesthetically pleasing and more maintainable!

See more ideas labeled with:
15 Comments
NicoleJ
Alteryx
Alteryx
‎06-17-2022 01:55 PM
Status changed to: Under Review

Designer Product team is currently investigating inclusion of this idea in conjunction with other requested new formula functions... Stay tuned!

 

NJ

 

0 Likes
NicoleJ
Alteryx
Alteryx
‎09-23-2022 07:46 AM
Status changed to: Accepted
 
NicoleJ
Alteryx
Alteryx
‎12-06-2022 10:23 AM
Status changed to: Coming Soon
 
0 Likes
NicoleJ
Alteryx
Alteryx
‎05-17-2023 02:09 PM
Status changed to: Implemented

The day has arrived!!!!

The Between function is now officially available as of the 23.1 release! 

Can't wait to see all the things you'll find between these beautiful parameters... Cheers!!

 

NicoleJ_0-1684357616093.png

 

 

 

 

ChrisTX
16 - Nebula
16 - Nebula
‎05-23-2023 03:42 AM

implemented in Version 2023.1 as a Function

New Formula Functions
Between (Min/Max Category)
https://help.alteryx.com/release-notes/designer/designer-20231-release-notes

https://help.alteryx.com/20231/designer/minmax-functions

 

Not implemented as an Operator, like the IN operator

https://help.alteryx.com/20231/designer/operators

 

@KylieF when an Idea is marked as Implemented, it would be helpful to include a short description of the implementation including the version number, and/or a link to documentation.

0 Likes
Labels