Where clause to filter on values from table

sifatnabil — Tue, 04 Oct 2016 14:43:49 GMT

Hi all,

I have a large QVD table that I want to filter by 150 "desk codes" (stored in an Excel sheet). What is the most efficient way of building a where clause that filters by these desk codes? Would left keep be fastest and the least RAM consuming? i.e.

DeskCodes:

LOAD

DeskCode

from [Excel.xlsx];

left keep

QVDTable:
DeskCode,

from [QVD.qvd] (qvd);

Re: Where clause to filter on values from table

sunny_talwar — Tue, 04 Oct 2016 14:44:48 GMT

May be this:

DeskCodes:

LOAD

DeskCode

from [Excel.xlsx];

QVDTable:
DeskCode,

from [QVD.qvd] (qvd)

Where Exists(DeskCode);

topic Where clause to filter on values from table in QlikView

Where clause to filter on values from table

Re: Where clause to filter on values from table