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)?
3 Likes
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:
2 Likes
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.