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.
2
Options
Marco_BoeckAdministrator, Moderator, Employee, Member, University ProfessorPosts: 1,993 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.
Answers
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.
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