Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bsbernabe
Creator
Creator

how to use except/ not exist in qlikview

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

Labels (1)
1 Solution

Accepted Solutions
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

you could use where and match like this

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

View solution in original post

2 Replies
StarinieriG
Partner - Specialist
Partner - Specialist

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')

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful