Row Filter by Values

Hi,

I’m using the Rules engine. Just wondering whether there is a single statement / statements I can use to filter for a value between a range of numbers.

For example my data range is from 1-100. I want to filter for values between 20-30 using the row rules based module.

Help appreciated.

Hi gwizard,

any reason you can’t use the ‘Row Filter’ Node? You can simply include/exclude a range of values by entering a lower and upper bound.
Using the ‘Rule-based Row Filter’ Node you can enter an expression such as

$Col1$ >= 20 AND $Col1$ <= 30 => TRUE

and then exclude/include TRUE matches.