Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Does Alteryx have a BETWEEN function or something similar?

mkeiffer
10 - Fireball
10 - Fireball

Hi there,

 

Does Alteryx Designer have a something similar to a BETWEEN function?  For example, if I wanted to find records with a transaction amount between 1,000 and 5,000 dollars, I could write a formula as follows:

 

BETWEEN(Transaction_Amount, 1000, 5000) 

 

And all of the records that had a transaction amount between and including 1,000 and 5,000 would be displayed.

 

Is there a similar function in Alteryx Designer, or must this expression be written the "long" way:

 

Transaction_Amount >= 1000 AND Transaction_Amount <= 5000

 

Thanks in advance for your help!

 

Mike

13 REPLIES 13
ArtApa
Alteryx
Alteryx
mkeiffer
10 - Fireball
10 - Fireball

@ArtApa Thanks so much for the heads up.  I just downloaded the new version today.  Thanks again!

NicoleJ
Alteryx
Alteryx

We have just released this new Between function today in our 23.1 release! Hope you can check it out! 😁

Cheers!
NJ
Sr. Manager, Product Management, Designer
Alteryx
mkeiffer
10 - Fireball
10 - Fireball

@NicoleJ Thank you so much! I just downloaded the latest version today. Thank you again for the heads up on this!

Labels