qlikview load millions records

[#1]

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

[martinpohl]

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

[#3]

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.

[prieper]

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

[erichshiino]

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