Empty values vs Null values

[AHerrera101499]

Hi Everyone,

I want to know a way to distinguish between null values and empty values because I used the isNull() function in the prepare recipe but that function didn't recognize that difference.

Regards

[JordanB · Accepted solution]

Hi @AHerrera101499,

You may reference the DSS documentation on formulas, specifically, isBlank and isNull: https://doc.dataiku.com/dss/latest/formula/index.html

For example, you can use in your formula: isBlank(col_1) or isNull(col_1)

Note, if you are running your prepare recipe in-database, you may experience a difference in execution then if you are running it with the dss engine. I would recommend using the dss engine in this case, if possible. 

Thanks,

Jordan

[AHerrera101499]

Thanks @JordanB for the help.