Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 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
HI Expertise,
Any solution on my issue
@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