Can't upload Excel table

mguidoum
mguidoum New Altair Community Member
edited November 2024 in Community Q&A
String index out of range 69. Please see attached screenshot.

Answers

  • kayman
    kayman New Altair Community Member
    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_Boeck
    Marco_Boeck New Altair Community Member
    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