Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Thanks