Problem with not in

[#1]

Hello everyone,

I have a trouble with the LOAD part in my script.

I want to do :

if (CODE<>('800','810','830,'410','420','900'), 'Not OK') as [Flow]

But it doesn't work.

Is someone have any solution ?

Thanks !

[PrashantSangle · Accepted solution]

Hi,

Try With wildmatch()

Like

if (not wildmatch(CODE,'800','810','830,'410','420','900'), 'Not OK') as [Flow]

Regards,

[its_anandrjs]

Try and write another way

if( NOT Match(CODE,'800','810','830,'410','420','900'), 'Not OK') as [Flow]

[MK_QSL]

IF(NOT MATCH(CODE,'800','810','830','410','420','900'), 'Not OK') as [Flow]

[maxgro]

=if ( not match(CODE,'800','810','830','410','420','900'), 'Not OK', 'OK') as Flow

[#6]

It works !

Thank you everyone