How do you pull data values in from a range of numbers?

[Dom]

I only want to pull data between the numbers 4 - 7 and 0 - 12.

[jack_morgan · Accepted solution]

Hey Dom,

Great to see you on here again. The attached workflow takes care of the 3 possible solutions you need:

1. 4-7
2. 0-12
3. 4-7 AND 0-12

Hope it helps!

[Dom]

Hello Jack,

I'm receiving an error when using both of the below expressions. 

if [HTIN]>=0 and [HTIN]<=12 then 1 else 0 endif

Does the version of Alteryx matter? I couldn't open the file. I had to modify the verion number in notepad to open in 9.5. We haven'r updated to 10.0 yet.

error: invalid type in operator >=

[MarqueeCrew · Accepted solution]

is the field that you are applying the formula to defined as Boolean or another numeric field type?  If it is a string, you'll get an error message because you are assigning a number to a character field.

just a guess....

[Dom]

Yes, that worked Mark. I changed the type.

[Dom]

After the filter what would use? Union? Assuming multiple filters like in the example.