Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
Start Free Trial

Alteryx Designer Desktop Discussions

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

How do I filter a range of numbers and do multiple filters?

testsubject000
5 - Atom

So I have a very large data set and I would like to extract certain numbers. They're not in sequential order and I would like to extract multiple records.

 

 

For example, for my sample data, I'd like to extract (1-4) and (7-11). How do I go about doing this?

 

I'd assume I'd use a custom filter but I"m not sure on what to put. I have about 20 different ranges I'd like to filter out so making a change of filters really isn't something I'd like to do.

2 REPLIES 2
EW
11 - Bolide

I've done something similar using a custom filter and the text input.  I find it a little easier to edit filters/ranges/whatever in the text input than within the filter.  

 

Does this get it done?

 

filterRanges.PNG

testsubject000
5 - Atom

Thank you :)

Labels
Top Solution Authors