We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Ideas

Share your Designer 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!

13 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