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