Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to exclude certain values from a load

Hi,

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,

Racine62

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

1)

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

View solution in original post

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

1)

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

Not applicable
Author

Thanks for this,

Regards,

Racine62