Nested if

[Madhusri]

Hi,

In a field status contains two values one is failure and another is success.

Where in failure it contains some description values also an null value.

Also in success it contain description as null value.

As I am confused how to check null condition as it contains in both failure and success descriptions.

Regards,

Madhusri R

[ITWhisperer]

isnull() and isnotnull() are the two functions you should look at e.g.

| eval status=if(isnotnull(description),"not empty","null")
| eval status=if(isnull(description),"null","not empty")