load values

[#1]

Hi all member ,i have this table in excel

Task	Type
T1	B
T1	X
T2	B
T2	C
T3	D
T3	X
T4	C

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

T2

T4

how i do that please

thanks

[Anonymous]

tmp:

load Task

where where upper(Type)='X'

Final:

load Task,

Type

from ..

where not exists (Task)

drop table tmp;

[swuehl]

LOAD Task as Exclude

FROM Excel.xls

WHERE Type = 'X';

LOAD Task, Type

FROM Excel.xls

WHERE NOT EXISTS(Exclude, Task);

[NareshGuntur]

Add

Where Type <> 'X'

to your load statement at the end

[sunilkumarqv]

Load

Task,

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

[PradeepReddy]

try like this...

LOAD Task,

     Type

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

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

[Anonymous]

Load * from tablename where Type <>'X'