Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QV have limit for loading date from .csv

Hi all!

I have the following problem:

i load date from .csv. Filesize is 1.4 gb.

QV load limit rows:

limit = 6 946 912.

But source .csv include 23 683 045.

Could you help me? What should i do for loading all rows to QV?

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

if i remember there is a limit in loading file csv, you can test change the parameter "Including" from "MSQ" to "Standard"

View solution in original post

6 Replies
jerrysvensson
Partner - Specialist II
Partner - Specialist II

Hi

I wasn't aware of that load limit, is it in the Reference manual?

Are you running 32 bits QlikView?

Which version of QV do you have?

Not applicable
Author

Hi,

if i remember there is a limit in loading file csv, you can test change the parameter "Including" from "MSQ" to "Standard"

rbecher
MVP
MVP

Hi Kseniya,

there should be not limit. I guess it's a problem in the data itself. Either wrong quoting parameter (try with parameter "no qoutes") or a structural problem. If you have a good text editor you should take a look at the data in record no. 6 946 913 and you will probably find something.


- Ralf



Astrato.io Head of R&D
Not applicable
Author

Thanks! It's work!

rbecher
MVP
MVP

But there is no limit, it's wrong use of quoting parameters here...

Astrato.io Head of R&D
Not applicable
Author

i should change the parameter "Including" from "MSQ" to "Standard" in Table Wizard