Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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