I need to convert a string to date. The issue I’m facing is that KNIME reads the missing values in the specific date column as ‘-’. When I try to convert the string to date I receive an error as KNIME is not able to parse ‘-’ to date.
Would anyone know how I can replace the ‘-’ value with a missing or NULL value so that I can use the string to date&time node?
May be this helps
Just the following rule is needed in the Rule Engine node:
NOT $Date$ LIKE “-” => $Date$
how do you read your data into KNIME? Some reader nodes have option to define missing value pattern so you can have missing values immediately when data is read into KNIME.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.