DSXchange

Hi
how to specify in the rule definition to find range operation for a data source?
for example if i want to find whether a column "column_a" has values in the range between "1 to 9"

i tried( column_a >=1 and column_a < 10 )
and column_a matches_regex '[1- 9]'

both are not working, can somebody please help me ?

thanks
MJ

What does "not working" mean here? Depending on the data type, both of the expressions you provided are valid.

hi ray, thanks for responding, the problem is, i'm trying to translate the below query into a rule, but i'm getting different row counts

query
=====
select count(1)
from table1
where col1 is null
and col4 = 'orange'
and column_a between 1 and 9
and col2 = "apple"

Data rule
======
if ( trim(col1)= ''
and col4 = 'orange'
and (column_a >= 1 and column_a <=9)
)
then
col2 = 'apple'

where i'm going wrong here, note: column_a is integer

Try using an EXISTS test on col1