Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sazabi
Creator
Creator

Load where not in load script?

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

2 Replies
joaopaulo_delco
Partner
Partner

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;

Help users find answers! Don't forget to mark a solution that worked for you!
rafaelsferreira
Contributor
Contributor

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.

 

table.png