"[SOLVED] Import Excel in RapidMiner - DATE has error"
zahrahnnx
New Altair Community Member
Answers
-
Hi,
the old 5.3 had a bug which caused the date format to selection textfield to get cut off. In the first screenshot you can see in the header row where the "Reload data" and "Guess value types" buttons are that on the right side it says "Date format". There should be a textfield next to it but it's not there. Can you increase the width of the dialog by dragging on the right side and see if it pops up?
The reason you only see "?" is that the default date format is not MM/dd/yyyy and as such it fails to parse the dates and replaces them with missing values.
Regards,
Marco0 -
Thanks MarcoMarco Boeck wrote:
Hi,
the old 5.3 had a bug which caused the date format to selection textfield to get cut off. In the first screenshot you can see in the header row where the "Reload data" and "Guess value types" buttons are that on the right side it says "Date format". There should be a textfield next to it but it's not there. Can you increase the width of the dialog by dragging on the right side and see if it pops up?
The reason you only see "?" is that the default date format is not MM/dd/yyyy and as such it fails to parse the dates and replaces them with missing values.
Regards,
Marco
It works
I expanded the window, so that the box showed up. and I added the date format "MM/dd/yyyy". Thanks a lot
0