Data import from Excel - limit on the number of records

Frequently Asked Questions about the SmartPLS software. Please refer to this section first, if you have problems with the software.
Post Reply
PLS Junior User
Posts: 2
Joined: Thu Jun 07, 2007 9:00 pm
Real name and title:

Data import from Excel - limit on the number of records

Post by oarazy » Fri Nov 08, 2013 9:09 am

I'm trying to import some data from Excel.
The CSV file is quite large with over 10,000 records.
When trying to import it into SmartPLS and validating the data, I get the error message: "3,725: The dataset 3,725 has 14 columns, but there are 20 indicators in total."
Once I truncated the file to only 3400 records, the import worked just fine.
Is there a limit on the file size (or number of records) that could be imported into SmartPLS?
Is there a way around this?

Ofer Arazy

User avatar
PLS Super-Expert
Posts: 905
Joined: Sat Oct 15, 2005 5:13 pm
Real name and title:
Location: São Paulo - BRAZIL

Post by Diogenes » Fri Nov 08, 2013 6:10 pm

usually this kind of message is caused by missing values or strings or simbols ($, %, NA, etc.) in the dataset.
Best regards,

Post Reply