Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi Use Match() function...
where match([Stock Movement Reason Code],'1','2')
Hope that helps
Sravan
hi Use Match() function...
where match([Stock Movement Reason Code],'1','2')
Hope that helps
Sravan