Does Alteryx have a BETWEEN function or something similar?

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

Workflow

Expression

Data Investigation

Accepted answers

ArtApa

Hi @mkeiffer - I'm afraid that you will need to write extra 18 characters based on your example. There is no between function in Alteryx. You can find the full list of functions in the documentation: https://help.alteryx.com/20223/designer/functions

Qiu

@mkeiffer
If you really hate Min and Max, we can try Bond? but this would also result extra 23 characters. 😁

0406-mkeiffer.yxmd

ArtApa

@mkeiffer - 2023.1 is here and it includes BETWEEN 😀: https://community.alteryx.com/t5/Analytics/2023-1-Enterprise-Ready-Cloud-Friendly/ba-p/1116702?utm_source=community&utm_medium=featured

NicoleJ

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

All comments

ArtApa

Qiu

@mkeiffer
If you really hate Min and Max, we can try Bond? but this would also result extra 23 characters. 😁

0406-mkeiffer.yxmd

danilang

Replace " And " with && to save 3 characters

[Transaction_Amount]>=1000&&[Transaction_Amount]<=5000

I'm actually surprised that that worked. I would have thought that the parser needed at least one space on either side of the &&

Dan

mkeiffer

@Qiu I really like this approach, despite the extra 23 characters! 😀 I tried using the Bound function earlier but I did not add the extra = [Transaction Amount] and now, that approach works as well.

Thank you for taking the time to respond to my post.

@danilang and @ArtApa thanks to both of you for taking the time to answer my post as well.

Qiu

@mkeiffer
Thank you for the feedback and I have also learned how to use this function. 😁

simonaubert_bd

Hello @Qiu The Between function will be available in a few days ! That was an idea proposed by the community (and that's why I encourage everyone to vote for ideas )
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/Add-quot-BETWEEN-quot-as-an-operator-function/idi-p/79219

https://community.alteryx.com/t5/Alter-Nation/You-Are-Invited-to-Alteryx-Public-Preview-23-1/ba-p/1089063

Best regards,

Simon

Qiu

@simonaubert_bd
That is nice.

Thanks.
Lets all go there and raise and vote for the ideas. 😁

ArnaldoSandoval

@simonaubert_bd @Qiu

It is coming soon, since 07-December last year, customs could be delaying its arrival 😀

Arnaldo

simonaubert_bd

@ArnaldoSandovalPlease note I wrote a few days, few being everything between (ahaha) 0 and infinite, as much as you consider it to be few.

On a positive side, the beta of 23.1 is here for months so I hope one day we will have a release.

Best regards,

Simon

ArtApa

@mkeiffer - 2023.1 is here and it includes BETWEEN 😀: https://community.alteryx.com/t5/Analytics/2023-1-Enterprise-Ready-Cloud-Friendly/ba-p/1116702?utm_source=community&utm_medium=featured

mkeiffer

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

NicoleJ

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

mkeiffer

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703