Does Alteryx have a BETWEEN function or something similar?

[mkeiffer]

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

[ArtApa · Accepted solution]

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 · Accepted solution]

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

[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...

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

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