KNIME does not recognize date value from a file, I have this excel file that contains data, one of the column contains date, but when I load it to KNIME, it does not recognized, I tried changing data type but no luck
Here’s my data
sample.xlsx - Google Tabellen
sample.xlsx (10.2 KB)
Here’s what I’m getting
there is something strange with your Excel file.
I tried to copy and paste your data on a new Excel file and everything was read as expected.
Another thing you could do is change the “posting date” column into the date format and then export the file as csv. Again, this is working on my KNIME.
Have a nice evening,
@spyglass and @lelloba , this issue rang bells, and whilst it might not be the same root cause, this looks remarkably similar to an issue that was raised here…
From what I can see on Windows 10, there are no clues like the ones you see on the Mac. Certainly not on mine anyway. File preview in Windows Explorer shows this:
but the Excel Reader shows this:
and I haven’t found anything in my copy of Excel that will tell me the stored locale of the dates, as they just automatically appear in my locale. On the “format cells” dialog it just shows me my locale too, with nothing to suggest the sheet is in actually in any other…
You have a strong memory
Seems that resaving the file or saving it as csv should do the job.
Let us know
Saving as .csv fixed the problem, Thanks
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.