topic Re: QV have limit for loading date from .csv in QlikView

QV have limit for loading date from .csv

Tue, 10 Dec 2013 12:18:05 GMT

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?

Re: QV have limit for loading date from .csv

jerrysvensson — Tue, 10 Dec 2013 14:20:26 GMT

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?

Re: QV have limit for loading date from .csv

Tue, 10 Dec 2013 14:28:01 GMT

Hi,

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

Re: QV have limit for loading date from .csv

rbecher — Tue, 10 Dec 2013 14:42:40 GMT

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

Re: QV have limit for loading date from .csv

Tue, 10 Dec 2013 14:54:46 GMT

Thanks! It's work!

Re: QV have limit for loading date from .csv

rbecher — Tue, 10 Dec 2013 14:57:57 GMT

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

Re: QV have limit for loading date from .csv

Tue, 10 Dec 2013 15:03:12 GMT

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