topic qlikview load millions records in QlikView

qlikview load millions records

Mon, 06 Jun 2011 08:47:41 GMT

Hi,

I have more than 6 millions records on Excel spredsheet. When i load into qlikview, it does load only 600k records. How can i make sure to load all records on qlikview without any break?

Hope someone will help me out.

Thanks

qlikview load millions records

martinpohl — Mon, 06 Jun 2011 09:49:33 GMT

Hello,

how did you realized 6 Mio records in Excel?

Excel 14 can only store 1 Mio records in one sheet.

Did you save the file in xlsx? And there are no "Null"-lines in?

Regards

qlikview load millions records

Mon, 06 Jun 2011 09:56:25 GMT

we have 6 mio records in CSV format. I have s/w that split number of rows lines into mulitple worksheets. There are chances to have "Null" values. Hope it makes sense.

qlikview load millions records

prieper — Mon, 06 Jun 2011 19:35:27 GMT

Have you tried to read the csv-file directly, and not the Excel?

Does the read-process always stop at the same line? Have you tried to read this line with an Editor? Alternatively you may delete this line and see, whether the load-process continues.

HTH
Peter

qlikview load millions records

erichshiino — Tue, 07 Jun 2011 00:42:29 GMT

If all the columns in a line are nulls the line will be ignored.

What's the script you used to read multiple worksheet? That may be the problem.

As Peter said, you could read the csv directly.

Regards,

Erich