Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i am fetching data from a QVD in the data editor and i would like to perform a SQL equivalent of WHER IN.
Can anybody tell me how to do this?
Basically like this:
LOAD
*
FROM [lib://MyFolder/test.qvd] (qvd)
WHERE (my_field NOT IN (20, 30)
;
Hi,
U can using match function
LOAD
*
FROM [lib://MyFolder/test.qvd] (qvd)
WHERE not match(my_field,'20','30');
There is no IN operator in QV/QS. Use Match instead:
WHERE (Match(my_field, 20, 30) = 0)
Hi,
U can using match function
LOAD
*
FROM [lib://MyFolder/test.qvd] (qvd)
WHERE not match(my_field,'20','30');
try this
where my_field not in('d','c','f');
Thank you!
Thank you!