In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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