Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

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
Highlighted
Partner
Partner

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?

Highlighted
Not applicable

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

Highlighted
MVP & Luminary
MVP & Luminary

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



Vizlib Head of R&D
Highlighted
Not applicable

Thanks! It's work!

Highlighted
MVP & Luminary
MVP & Luminary

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

Vizlib Head of R&D
Highlighted
Not applicable

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