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
where where upper(Type)='X'
where not exists (Task)
drop table tmp;
LOAD Task as Exclude
WHERE Type = 'X';
LOAD Task, Type
WHERE NOT EXISTS(Exclude, Task);
Where Type <> 'X'
to your load statement at the end
Type from datasource where Type <> 'X' and Type<> 'x';
try like this...
FROM Test.xlsx (ooxml, embedded labels, table is Sheet1)
where not WildMatch(Task&Type,'*X*');
Load * from tablename where Type <>'X'
Retrieving data ...