IF Condition with a list

[gfisch13]

Hi folks - I'm trying to crreate an filter box within my script and I keep getting "missing )" errors.

I'm selecting values from a field that are either Included or Excluded.  I just can't seem to get the syntax right.  Any help is appreciated.

Am I using the correct function with MATCH??

if(match(SCBCOUNTRY='AE','BH','QA'), 'Excluded', 'Included') as CountryInd,

Thanks, George

[Or]

if(match(SCBCOUNTRY,'AE','BH','QA'), 'Excluded', 'Included') as CountryInd,

Wrong syntax for match. It doesn't take an equal sign.

[AshutoshBhumkar]

Hello,

Maybe something like below.

Function is correct but some syntax error.

if(match(SCBCOUNTRY , 'AE','BH','QA'), 'Excluded', 'Included') as CountryInd

Thanks,

Ashutosh