If and not like...

[#1]

Hi everybody,

i gat an issue i have a table, and i want to add a field but i don't manage with the conditionnal logics.

FACTURE_INDICATEUR3:

LOAD

     FACTURE_INC.GPE_CLIENT,

     FACTURE_INC.CodifCreno,

     Catalogue_marque,

     catalogue_famille,

     if ((catalogue_famille='LEGUMES 4G') and (FACTURE_INC.GPE_CLIENT='RESTALLIANCE') and (Catalogue_marque  not like API* ),'OK','Interdit') as Test

FROM

FACTURE_INDICATEUR.QVD

(qvd);

But there is a problem with the not like.. any one can help me?

Thanks you so much ! And sorry for my bad english !

[Gysbert_Wassenaar]

Try and not wildmatch(Catalogue_marque, 'API*')

[jagan · Accepted solution]

Hi,

Try like this

FACTURE_INDICATEUR3:

LOAD

     FACTURE_INC.GPE_CLIENT,

     FACTURE_INC.CodifCreno,

     Catalogue_marque,

     catalogue_famille,

     if ((catalogue_famille='LEGUMES 4G') and (FACTURE_INC.GPE_CLIENT='RESTALLIANCE') and (not Catalogue_marque   like 'API*' ),'OK','Interdit') as Test

FROM

FACTURE_INDICATEUR.QVD

(qvd);

[#4]

Thanks a lot everybody !!!