QV have limit for loading date from .csv

[#1]

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?

[jerrysvensson]

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?

[#3 · Accepted solution]

Hi,

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

[rbecher]

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

[#5]

Thanks! It's work!

[rbecher]

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

[#7]

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