Load where not in load script?

[Sazabi]

Salutation Qlik Artisans,

I have a question on how to write a load RESIDENT where a value is not like 'x' or 'y'.

I have written this. The goal is exclude loading where the first character is T or last character is a 2.

INL:
load * inline [T,
TI2080
TI20802
wololol];

INL_Final:
NoConcatenate
load * resident INL
where (LEFT(T,1) <>'T') or (right(T,1) <> '2');

drop table INL;
exit script;

My resulting table contains:

TI20802

wololol

Why didn't it drop TI20802?

Thanks!

S

[joaopaulo_delco]

Hey Buddy! Try this:

INL:
load * inline [T,
TI2080
TI20802
wololol];

INL_Final:
NoConcatenate
load * resident INL
where  not WildMatch(T,'T*') and not WildMatch(T,'*2');

drop table INL;
exit script;

[rafaelsferreira]

Hi,

I don't know if I understand correctly what you want to do. Anyway, Below is a table of what is happening in your script. As I understand it, you need to use the logical operator and.