We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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