how to use except/ not exist in qlikview

[bsbernabe]

Hello There,

How to make script loading data to remove value not need sample I want to remove 300, 285 in a list. how can I do that?

Sample Data:

Code

300

285

299

56

216

The result should be:

Code

299

56

216

Best Regards,

Bing

[StarinieriG · Accepted solution]

Hi,

you could use where and match like this

LOAD
Code
From File
Where Match(Code, '300','285')=0;

[Anil_Babu_Samineni]

Perhaps this in the end of load script?

Where Not Match(Code, '300', '285')