Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to use Where not match function ,but it error ,Where I wrong?
Please help me.
Thank you.
yyou cannot use like that in the field list try like
LOad field1,
field2
.
.
.
from tablename
where not match(Knot_mc_kat, ‘GF-Stock’,’NON-Fab’);
yyou cannot use like that in the field list try like
LOad field1,
field2
.
.
.
from tablename
where not match(Knot_mc_kat, ‘GF-Stock’,’NON-Fab’);
Try this:
DFIT_KNIT_YEAR:
LOAD
KNIT_MC_YEAR,
IF(NOT MATCH(KNIT_MC_CAT,'GF-STCOK','NON-FAB'),KNIT_MC_CAT) AS KNIT_MC_CAT,
KNIT_MC_GROUP,
.....
From abc;
or
try this
write below code as last line
where field not in('Value1','Value2');