topic Re: Load where not in load script? in App Development

Load where not in load script?

Sazabi — Fri, 05 Jun 2020 18:42:28 GMT

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!

Re: Load where not in load script?

joaopaulo_delco — Fri, 05 Jun 2020 18:58:07 GMT

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;

Re: Load where not in load script?

rafaelsferreira — Sun, 07 Jun 2020 21:56:14 GMT

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.