I need to include a specific number range in my data set.

[Alexgray25]

Hi Guys,

Sorry i am new to this Alteryx and i only need to include a certain range of numbers from my "material" column in my data set.

i have a range of numbers between 2500000000 - 2900000000 and i only want to use 2700000000 - 2799999999.

What is the best way to do this?

Thanks

Alex

[atcodedog05]

Hi @Alexgray25 

I would say filter tool.

https://community.alteryx.com/t5/Interactive-Lessons/Filtering-Data/ta-p/76301

But i am not completely clear with the requirement 😅

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

[terry10]

use a filter tool with a custom formula:    [material] >= 2700000000 && [material] <= 2799999999

This is a big data set, so remove or disable unneeded browse tools to have it run faster.

[Alexgray25]

Thanks Terry worked perfectly!