Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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