Where condition in QVD file

[upaliwije]

I am loading data from a QVD file with a where condition as follows

Load *

......

(qvd)

WHERE NOTE>=100  AND NOTE<=1000 AND  YEAR>=2014 and MONTH=1;

This where condition I want to modify as follows

WHERE NOTE>=100  AND NOTE<=110 and NOTE>=120  AND NOTE<=1000 AND  YEAR>=2014 and MONTH=1;

Is this possible ? pls educate me.

[kamalqlik]

Hi Please apply the below logic.

where ((note >=100 and  note <=110) or (note >=120 and note <=1000)) and year >= 2014 and month=1;

Regards,

Kamal

[upaliwije]

Thanks