Creating a new column based on IF-ELSE condition for missing values

Hi All,

I have a column which contains dates and many of those rows are missing.
I want to create a seperate column where if date is missing I want to create flag as “Active” and if date is present, then flag it as “Inactive”

Hello @abishaymathewd,

and welcome to KNIME Community!

I would use Rule Engine node with MISSING operator. Something like this:

MISSING $colName$ => "Active"
TRUE => "Inactive"

Br,
Ivan

3 Likes

thanks a lot @ipazin. Code worked like a charm. :smiley:

1 Like