Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Limited import of records in xls

I 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?

Find more posts tagged with

AI Studio

Excel

Getting Started

Accepted answers

Telcontar120

It should only be a limit in the preview. Did you try running the import to see whether you got all your records?

All comments

Telcontar120

It should only be a limit in the preview. Did you try running the import to see whether you got all your records?

rfuentealba

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.