Empty values vs Null values

Options
AHerrera101499
AHerrera101499 Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 14

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

Best Answer

  • JordanB
    JordanB Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 293 Dataiker
    Answer ✓
    Options

    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

Answers

Setup Info
    Tags
      Help me…