Nested if

Madhusri — Mon, 13 Sep 2021 11:31:12 GMT

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

Re: Nested if

ITWhisperer — Mon, 13 Sep 2021 12:08:03 GMT

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")