Excluding some values while loading

[kailashkotak91]

Hello Everyone,

I am loading the data from SQL server. Can someone help me to exclude some data when I load in QlikView.

I have more than 5000 values in a column and i want to exclude 35 of those values when I load data. Can someone tell me a better way than where clause ?

Thanks in advance

Regards,
Kailash Kotak.

[maxgro]

It seems to me a good solution to exclude the values using a sq serverl where clause (not in (....))

Why you don't like it?