topic Re: load values in QlikView

load values

Mon, 25 Jan 2016 12:38:14 GMT

Hi all member ,i have this table in excel

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

how i do that please

thanks

Anonymous — Mon, 25 Jan 2016 12:56:55 GMT

tmp:

load Task

where where upper(Type)='X'

Final:

load Task,

Type

from ..

where not exists (Task)

drop table tmp;

swuehl — Mon, 25 Jan 2016 12:57:16 GMT

LOAD Task as Exclude

FROM Excel.xls

WHERE Type = 'X';

LOAD Task, Type

FROM Excel.xls

WHERE NOT EXISTS(Exclude, Task);

NareshGuntur — Mon, 25 Jan 2016 12:59:09 GMT

Add

Where Type <> 'X'

to your load statement at the end

sunilkumarqv — Mon, 25 Jan 2016 13:06:06 GMT

Load

Task,

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

PradeepReddy — Mon, 25 Jan 2016 13:07:40 GMT

try like this...

LOAD Task,

Type

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

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

Anonymous — Mon, 25 Jan 2016 13:15:00 GMT

Load * from tablename where Type <>'X'