Loading the values of xls as where condition in one of the load statement!

[qlikviewforum]

Hi All,

I have xls which contain field called "ID" and it has following values.

ID

ABC

XYZ

QRS

ASP

Basically I want to use the above values in WHERE condition of one of the load statement something like below.

Load * From data.qvd

Where Not Match( ID, 'ABC', 'XYZ', 'QRS', 'ASP')

Can someone help me out for the same please. It is little urgent!

[brijesh1991]

It's the correct answer and dear questionnary this is what you are looking for.

Map: Mapping LOAD ID, '1' from xls load* from data.qvd where applymap('Map', ID) <>1;