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: 
Anonymous
Not applicable

Exclude records form QVD load

I have trolled and trolled and still don't get what seems to a very simple thing. I am loading from a qvd.  I just want to exclude about 40 specific records from the load, but I cannot seem to make it work.  SQL "Not in" does not work, not match does not work, not = does not work... Any ideas?

1 Solution

Accepted Solutions
gussfish
Creator II
Creator II

OK, in that case the Match() function is the simplest solution; viz

LOAD

     case,

     ... // your other fields

FROM yoursource.ext(...)

WHERE not Match(case,17, 21, 39, 155);

Angus.

View solution in original post

5 Replies
gussfish
Creator II
Creator II

It depends on the degree of complexity of your criteria.  What is your basis for deciding which records to keep and which to discard?

Anonymous
Not applicable
Author

I have let’s say ten thousand records loading from the qvd where field “case” is 1, 2, 3, …10,000.

I want to exclude 40 very specific records where “case” is 17, 21, 39, 155…

gussfish
Creator II
Creator II

OK, in that case the Match() function is the simplest solution; viz

LOAD

     case,

     ... // your other fields

FROM yoursource.ext(...)

WHERE not Match(case,17, 21, 39, 155);

Angus.

Anonymous
Not applicable
Author

BINGO!  Thank you Angus!

gussfish
Creator II
Creator II

Another satisfied customer