Where clause to filter on values from table

[sifatnabil]

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,

A,

B

from [QVD.qvd] (qvd);

[sunny_talwar · Accepted solution]

May be this:

DeskCodes:

LOAD

DeskCode

from [Excel.xlsx];

QVDTable:
DeskCode,

A,

B

from [QVD.qvd] (qvd)

Where Exists(DeskCode);