Load all rows except few

[that_anonymous_guy]

I have a table having 4 fields. A B C D

load a,b,c,d from <src>

I don't want to load rows having c as 4 and 5. 

Could someone please help me with this?

[E_Røse · Accepted solution]

Try something like:

load a,b,c,d from <src> where match(c, 4,5)=0;

The match-function returns 0 when there is no match, otherwise it returns 1 if c is 4, and 2 if c is 5,( the numeric location of the expressions that match ).

Please like and mark my answer as a solution, if it resolved your issue.

https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/Scripting/Conditiona...