csv file stops at 130,000 lines

[#1]

Hi,

I have experienced a strange problem in Qlikview 10.

My csv file, delimited with a | ,has exceeded 130,000 lines and Qlikview is not loading all of the data in the csv file. It cuts off the data around 130,000 lines

I thought it could be that this is close to double the old 2003 spreadsheet row limit of 65,000 ish rows

Anyone experience this??

David

[Miguel_Angel_Baeyens]

Hi David,

I've just created a CSV file using "|" as field separator with 1 million rows and loads fine in QlikView SR4 update. What error do you receive?

Miguel

[#3]

Hi,

For anyone else who may have this problem I got the solution from our local Qlikview rep, Thanks Brad from ABM Systems in Sydney.

Just remove "msq" from the load and it fixes the problem.

e.g. see below

FROM (txt, codepage is 1252, no labels, delimiter is '|',msq) ;

Thanks,

David