Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
hrlinder
Honored Contributor

Re: load values

tmp:

load Task

where where upper(Type)='X'

Final:

load Task,

Type

from ..

where not exists (Task)

drop table tmp;

MVP
MVP

Re: load values

LOAD Task as Exclude

FROM Excel.xls

WHERE Type = 'X';

LOAD Task, Type

FROM Excel.xls

WHERE NOT EXISTS(Exclude, Task);

nareshguntur
Valued Contributor

Re: load values

Add

Where Type <> 'X'

to your load statement at the end

sunilkumarqv
Valued Contributor II

Re: load values

Load

Task,

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

pradeepreddy
Valued Contributor II

Re: load values

try like this...

LOAD Task,

     Type

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

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

balrajahlawat
Esteemed Contributor

Re: load values

Load * from tablename where Type <>'X'

Community Browser