Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

load values

Hi all member ,i have this table in excel

Task

Type

T1

B

T1

X

T2

B

T2

C

T3

D

T3

X

T4C

i want to load Task that doesn't have  an 'X' Type the result like

T2

T4

how i do that please

thanks

6 Replies
Anonymous
Not applicable
Author

tmp:

load Task

where where upper(Type)='X'

Final:

load Task,

Type

from ..

where not exists (Task)

drop table tmp;

swuehl
MVP
MVP

LOAD Task as Exclude

FROM Excel.xls

WHERE Type = 'X';

LOAD Task, Type

FROM Excel.xls

WHERE NOT EXISTS(Exclude, Task);

NareshGuntur
Partner - Specialist
Partner - Specialist

Add

Where Type <> 'X'

to your load statement at the end

sunilkumarqv
Specialist II
Specialist II

Load

Task,

Type from datasource where Type <> 'X' and Type<> 'x';

PradeepReddy
Specialist II
Specialist II

try like this...

LOAD Task,

     Type

FROM Test.xlsx (ooxml, embedded labels, table is Sheet1)

where not WildMatch(Task&Type,'*X*');

Anonymous
Not applicable
Author

Load * from tablename where Type <>'X'