topic LOAD/SELECT, skip specific records in QlikView

LOAD/SELECT, skip specific records

Wed, 16 Nov 2011 17:25:23 GMT

I have two product numbers (01 and 52) that I would like to skip when loading my table. I get a syntax error and can't get this to work any other way. Can anyone tell what the syntax should be, whether the exclusion takes place in the SELECT or the LOAD statement, also. Thank you so much.

My code looks like this:

LOAD.......;

SQL SELECT

CategoryID,

ProductNo,

ProductName

FROM 'Finished Products Table'

WHERE ProductNo NOT '01' AND

ProductNo NOT '52'

;

LOAD/SELECT, skip specific records

Anonymous — Wed, 16 Nov 2011 17:30:05 GMT

WHERE ProductNo NOT IN ( '01', '52')

LOAD/SELECT, skip specific records

Wed, 16 Nov 2011 17:32:33 GMT

LOAD.......;

SQL SELECT

CategoryID,

ProductNo,

ProductName

FROM 'Finished Products Table'

WHERE ProductNo <> '01'

AND ProductNo <> '52';

LOAD/SELECT, skip specific records

Wed, 16 Nov 2011 18:29:47 GMT

Thank you both! Could have done it either way.