In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Setting an interval in expression.

Mike11Lee
5 - Atom

I want to write a formular that can select the number in a specific interval. for example, I want to use fulter tool to pick 2,3, and 4.

 

If I use 【n IN (2,4)】, then I can only get 2 and 4. Can I use a simgle expression to do this job?

 

Mike11Lee_1-1671676360739.png

 

3 REPLIES 3
PanPP
Alteryx Alumni (Retired)

Hi @Mike11Lee 

 

I have uploaded a sample WF that uses a filter tool to get values 2-4.

Mike11Lee
5 - Atom

Thanks to reply, I wonder if there exist a shorter expression, such as 2 <= [n] <= 4 (I have tried this expression, didn't work) that only need one [n].

PanPP
Alteryx Alumni (Retired)

That wouldn't be a valid expression within the Filter tool.

Labels
Top Solution Authors