πŸ¦‰πŸ¦‰   WOOT WOOT!   RAPIDMINER WISDOM 2020 EARLY BIRD REGISTRATION ENDS FRIDAY DEC 13!   REGISTER NOW!   πŸ¦‰πŸ¦‰

Can't upload Excel table

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

Answers

  • kaymankayman Member Posts: 416   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.Β 
    varunm1Tghadially
  • Marco_BoeckMarco_Boeck Team Lead Software Engineering Administrator, Moderator, Employee, Member, University Professor Posts: 1,851   RM Engineering
    edited August 12
    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
    Tghadially
Sign In or Register to comment.