Missing Value node - not working due to "?"

I am trying to put a text instead of a missing value. However, the node does not work because KNIME populates a ? when it reads the file.
Any suggestions on which nodes to use instead?

Thank you

Is it really a missing value (red ?) or just a string with a question mark (black text)?



Hi @tinnefleerakkers,

You can use this expression in the String Manipulation node before the Missing Value node to solve the issue:

toNull(regexReplace($column1$, "^\\?$", ""))

Where column1 is the name of the target column.

If you have several columns to manipulate, take a look at this topic and apply the current expression with the same method I have suggested:



This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.