where clause NOT IN load data

[hariishr]

hi,

i want to know is there any function equivalent in QLIK SENSE ==>  WHERE IN / WHERE NOT IN .

using data load editor want to modify data input. 

kindly answer for both scenarios.

SQL EXAMPLE1:

SELECT * FROM Customers
WHERE Country IN ('Germany', 'France', 'UK');

SQL example 2:

SELECT * FROM Customers
WHERE Country NOT IN ('Germany', 'France', 'UK');

[ArnadoSandoval]

Hi @hariishr 

Please take a look at the Exists function !!!

HTH

[Or]

What you're looking for is the Match(), MixMatch(), and WildMatch() functions. You can also use e.g. NOT Match().