Options

Can't upload Excel table

mguidoummguidoum Member Posts: 2 Contributor I
edited August 2019 in Help
String index out of range 69. Please see attached screenshot.
Tagged:

Answers

  • Options
    kaymankayman Member Posts: 662 Unicorn
    What happens if you import 'as is', so without using the import Wizard, and tick import all as nominal?

    Sometimes things go wrong as the Wizards use the First rows to guess the datatype, but with mixed types this can cause issue's in some conditions. 
  • Options
    Marco_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,996 RM Engineering
    edited August 2019
    Hi,

    That's an old .xls file, right? Can you let Excel convert it to the .xlsx format (standard since over a decade) and try again? These are handled by different libraries inside RapidMiner Studio. The old format may not be supported very well if there's weird stuff in it.

    Regards,
    Marco
Sign In or Register to comment.