We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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

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!

15 Comments
NicoleJ
Alteryx
Alteryx
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

 

NicoleJ
Alteryx
Alteryx
Status changed to: Accepted
 
NicoleJ
Alteryx
Alteryx
Status changed to: Coming Soon
 
NicoleJ
Alteryx
Alteryx
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
15 - Aurora

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.