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

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.