topic not loading all the rows from a text file in QlikView

not loading all the rows from a text file

Anonymous — Mon, 13 Aug 2012 15:23:02 GMT

Hi,

I have a strange problem.i have text file of 1.1 GB with no. of records- 1.5 millions while loading it into qlikview it only pulls 670k record only.

so i spilted the text file into 2 each of it with of 600 MB.with no. of record - 750k ..while loading it into qlikview

it pull only 356 k records..

why it so ..is there any limit for qlikview ?

Mon, 13 Aug 2012 15:34:55 GMT

Check to see in your editor that it is reading the first 10 lines properly.

There's a chance that the text file doesn't have a carriage return line feed at the end of every row.

Are there empty rows in your source?

Can you identify the missing rows?

Anonymous — Mon, 13 Aug 2012 15:42:15 GMT

thanks for your time and reply

Check to see in your editor that it is reading the first 10 lines properly.

yes, its reading properly ..because my application doesn't break while those 370k records are loaded.

There's a chance that the text file doesn't have a carriage return line feed at the end of every row.

if it is so, how to check this and how to fix this ?

Are there empty rows in your source?

no, there no empty fileds text doc is from database. we are sure about this

Can you identify the missing rows?

no missing rows and all missing data is regarded as null

Mon, 13 Aug 2012 15:44:34 GMT

Can you pull directly from the database?

Anonymous — Mon, 13 Aug 2012 15:48:36 GMT

ya i.e is main problem , for some reason ... we are not provided with credentails

Tue, 25 Sep 2012 10:57:23 GMT

I have had a similar problem.

It was solved using the solution proposed here : http://community.qlik.com/message/189249#189249

Regards

Kenn