Cannot get WHERE statement to work in script..

hopkinsc — Wed, 28 Sep 2011 11:20:12 GMT

Hi, I am trying to use a where statement in my script to only load in specific Stock Movement Codes but i can not get it to work.

Can anyone help me please?

I have tried ..

FROM $(cFileName) (qvd) where [Stock Movement Reason Code]='1,2,19,21,22,34,35,62,3,5,16,18';

FROM $(cFileName) (qvd) where [Stock Movement Reason Code]=('1,2,19,21,22,34,35,62,3,5,16,18');

FROM $(cFileName) (qvd) where [Stock Movement Reason Code]=1,2,19,21,22,34,35,62,3,5,16,18;

Thanks

Wed, 28 Sep 2011 11:23:00 GMT

hi Use Match() function...

where match([Stock Movement Reason Code],'1','2')

Hope that helps

Sravan

topic Cannot get WHERE statement to work in script.. in QlikView