The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Limited import of records in xls
Learner II have an RM Studio Small license - Limited to 100K rows. However, when I attempt to bring in xlsx file (Add Data) it is limiting me to only bringing in 5000 rows, stating "Sheet content too large". Is this limitation referring just for the preview and I can assume the model will use all my records (40k)? Or, is something wrong with my setup?
Tagged:
0
Best Answer
-
Telcontar120
RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 
Unicorn
It should only be a limit in the preview. Did you try running the import to see whether you got all your records?
6
Answers
Not sure if this is your case, but was mine:
If you don't know how many rows are in your .xls file, you should make sure to put only column names (A:E) instead of a fixed number of rows (A1:E5000). The former takes in account all the values from columns A to E, while the latter only takes in account the values from row 1 to row 5000 and columns A to E.
I always make that same mistake.