Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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
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
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
Thanks @JordanB for the help.