Where not match

[penpayom]

Hi 

I want to use Where not match function ,but it error  ,Where I wrong?

Please help me.

Thank you.

[vishsaggi · Accepted solution]

‌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’);

[balabhaskarqlik]

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;

[Chanty4u]

or

try this

write below code as last line

where field not in('Value1','Value2');