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