Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jhlovenc
Contributor II

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
Contributor II

Re: Exclude records form QVD load

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.

5 Replies
gussfish
Contributor II

Exclude records form QVD load

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

jhlovenc
Contributor II

Re: Exclude records form QVD load

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
Contributor II

Re: Exclude records form QVD load

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.

jhlovenc
Contributor II

Exclude records form QVD load

BINGO!  Thank you Angus!

gussfish
Contributor II

Exclude records form QVD load

Another satisfied customer