topic Exclude records form QVD load in QlikView

Exclude records form QVD load

Anonymous — Wed, 01 Feb 2012 01:35:36 GMT

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?

Exclude records form QVD load

gussfish — Wed, 01 Feb 2012 01:53:42 GMT

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

Re: Exclude records form QVD load

Anonymous — Wed, 01 Feb 2012 01:58:43 GMT

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…

Re: Exclude records form QVD load

gussfish — Wed, 01 Feb 2012 02:10:00 GMT

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.

Exclude records form QVD load

Anonymous — Wed, 01 Feb 2012 02:36:19 GMT

BINGO! Thank you Angus!

Exclude records form QVD load

gussfish — Wed, 01 Feb 2012 02:37:42 GMT

Another satisfied customer