Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
if(match(SCBCOUNTRY,'AE','BH','QA'), 'Excluded', 'Included') as CountryInd,
Wrong syntax for match. It doesn't take an equal sign.
Hello,
Maybe something like below.
Function is correct but some syntax error.
if(match(SCBCOUNTRY , 'AE','BH','QA'), 'Excluded', 'Included') as CountryInd
Thanks,
Ashutosh