I would like to compare some columns in two tables and output the comparison result. I have mostly achieved what I wanted however I am having some problems with comparing columns which contain Dates. Not every row will contain a plausible date (some users included some comments as well) therefore I need to use the column as string in KNIME.
In both excel files the following is visible “01.10.2019” however one table contains this information formatted as string while the other has this as DateTime. When importing to KNIME the string will be imported unchanged as “01.10.2019” while the DateTime will be imported as “01-10-2019”. Now these strings will evaluate to be different but the information is in fact the same.
Do you have any idea how to deal with this?