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!
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.
Hi Laurent,
You should be able to use the syntax :
if (isBlank(ColA),'Missing','Present')
Hi Laurent,
You should be able to use the syntax :
if (isBlank(ColA),'Missing','Present')
Hi and thanks, it was indeed just a question of syntax. Kindest regards.