The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

"[SOLVED] Import Excel in RapidMiner - DATE has error"

zahrahnnxzahrahnnx Member Posts: 9 Contributor II
edited June 2019 in Help
Dear everyone
I have tried to import an excel file in RM 5.3. One of the columns in the excel file has date format, but after importing RM does not show the date, there is only question mark (?). May you help me to fix the problem?

image

image

image
Tagged:

Answers

  • Marco_BoeckMarco_Boeck Administrator, Moderator, Employee-RapidMiner, Member, University Professor Posts: 1,996 RM Engineering
    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
  • zahrahnnxzahrahnnx Member Posts: 9 Contributor II
    Marco 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
    Thanks 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 :)

    image
    image
Sign In or Register to comment.