Fill in missing Values in a column with none or unknown.

[armingrudd]

Hi @sgilmour,

Have you noticed these topics:

replace empty fields

You could use the toNull() function in the String Manipulation node to convert blanks to missing values, and then handle all missings at once with the Missing Value node.

replace empty cell with missing (?) globally in table

Hi Both, how about using the Column Auto Type Cast for this: You can define a Missing Value pattern in the dialog. If you do this, it will automatically transform all emptys to Missing Values (And as a nice Side Effect the columns are automatically converted to the best fitting type) https://hub.knime.com/knime/nodes/Column_Auto_Type_Cast*iQCmMxBEl2szprD5 Cheers, Iris