Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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.