considering null values in script

[smilingjohn]

Hi All, 

I have a field called  Category which has  many  null values   as shown in the  screenshot  below . 

I am trying to  consider null values in the script like this 

If(Isnull( Category),'NULL',Category) as CAT, but this is not renaming the null values , it remains the same 

 Can you please help me in handling this ? 

Thanks in Advance 

[vchuprina · Accepted solution]

Hi,

Looks like null and (null) are not nulls it’s a text, so probably your expression should be

IF(Wildmatch(Category, '*null*') or IsNull(Category), 'NULL', Category) AS Category

Also if you have empty rows you can add third condition

IF(Wildmatch(Category, '*null*') or IsNull(Category) or trim(len(Category))=0, 'NULL', Category) AS Category

Regards,

Vitalii