Discussion board where members can get started with QlikView.
I've got load fields with values I want to exclude eg "#Null!","9", etc. Can one do this for individual fields?
Any help thanks,
Go to Solution.
Select * from ...
Where Field1 <> null and Field1 <>'9' and Field2 <> '4'
Load data wher Field1 is not null and will never contain value 9 and field2 will never contain value 4
Thanks for this,