empty cell and null values

[smilingjohn]

Hi Expertise ,

I have to bucket certain values of the field Environment which has the entry as 'null' and also there as some empty cells with no entries  to which i have to include both 'null ' and blank entries into Unknown . to do so i am trying to use belwo script but this is not working . Can you pease help me on this ? but this below expression gives me reloading error like wrong expression 

Script:

if(WildMatch(ENVIRONMENT,'Green','Green  '),'Green',
if(WildMatch(ENVIRONMENT,'Check','Harvesting'),'UnderDev',
if(WildMatch(ENVIRONMENT,'Better'),'Better',
if(WildMatch(ENVIRONMENT,'null'or
IsNull(ENVIRONMENT),'UNKNOWN',
))))) as environment

Thanks in advance 

[smilingjohn]

HI Expertise,

Any solution on my issue 

[sunny_talwar · Accepted solution]

@smilingjohn try this

If(WildMatch(ENVIRONMENT, 'Green*',), 'Green',
If(WildMatch(ENVIRONMENT, 'Check', 'Harvesting'), 'UnderDev',
If(WildMatch(ENVIRONMENT, 'Better'), 'Better',
If(WildMatch(ENVIRONMENT,'null') or IsNull(ENVIRONMENT), 'UNKNOWN')))) as environment