WHERE Condition to ignore the records which contains the given record.

[qlikviewforum]

Hi All,

I want to ingore the the value in the field called "ID" which contains the value as 'XYZ','ABC','QRS' and 'ASP' while loading the data from a table. Please let me know thw WHERE condition for the same.

[#2]

add this line to the end

where ID<>'XYZ' and ID<>'ABC' and ID<>'QRS' and ID<>'ASP'

[tresesco · Accepted solution]

Like:

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

[jagan]

Hi,

Try using WildMatch() in your where statement

Data:

LOAD

*

FROM DataSource

Where Not WildMatch( ID, 'ABC', 'XYZ', 'QRS', 'ASP');

Regards,

Jagan.

[qlikviewforum]

Hi All,
Thank you for your suggestions. It did work!

By the way I want to create xls called ID_Exclude.xls where it will contain all the values that need to be excluded.Some thing like below...

ID
--
ABC
XYZ
QRS
ASP

So I need exclude all the values which is there in the xls.(i.e) These value should be used in the WHERE condtion.