Can't upload Excel table

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

Answers

  • kaymankayman Member Posts: 662 image 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. 
  • Marco_BoeckMarco_Boeck Administrator, Moderator, Employee-RapidMiner, Member, University Professor Posts: 1,996 image 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.