how to logic the null value

[WuCong]

I want to use a field value is null or not ,while I use isnull(coulmnA), I can not get the result I want. it confused me .

I want to Flag the value is null as 1,and not null as 2.

and I want to flag the value is not null and not equal 'A' as 3.

[AMiller_Tri · Accepted solution]

Hi @wu cong? , thank you for your question.

Trifacta differentiates between an empty value (meaning the field is simply empty) and a null value:

Indeed, to identify a null value, you can use the function ISNULL()

To identify a value that is either empty or null, you can use the function ISMISSING()

To identify an empty value, you can use equality, like PHONE_NUMBER=="" . Meaning - is an empty string.

In the picture above, I'm using the "case-custom condition" transform to add multiple cases, as per your scenario.

You can change the fields to what your goal is.

I've used the ISMISSING() function in the 2nd condition because conditions' order in a case condition takes precedence. So if the first condition wasn't met, it means the ISMISSING() will only find empty values, not null values.

I hope that makes sense.

Feel free to ask any further questions.

Thanks,

Amit.

[WuCong]

Great?thanks a lot