If given column is blank returns a given value
LaurentS
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
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,226 Dataiker
Hi Laurent,
You should be able to use the syntax :
if (isBlank(ColA),'Missing','Present')
Answers
-
LaurentS 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.