If given column is blank returns a given value

Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Dataiku DSS Adv Designer, Registered Posts: 21 ✭✭✭✭

Hello,

I have tried several ways, but it remains in error:

(1) I have a given columpn (say ColA) in which there are empty values

(2) I want to create a new column, given the formul : If in ColA, there is blank value, then returns 'Missing', otherwise, returns 'Present'. To do this, I am using the recipe 'Cleaning' and using the formula ("add a new step")

Here is the formula and I do not understand why it is invalid

if (ColA isBlank,'Missing','Present')

Thanks for your help.

Best Answer

  • Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,269 Dataiker
    edited July 2024 Answer ✓

    Hi Laurent,

    You should be able to use the syntax :

    if (isBlank(ColA),'Missing','Present')

    Screenshot 2021-07-19 at 11.04.14.png

Answers

  • Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Dataiku DSS Adv Designer, Registered Posts: 21 ✭✭✭✭

    Hi and thanks, it was indeed just a question of syntax. Kindest regards.

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.