Discussion Board for collaboration on QlikView Scripting.
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 ?
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?
thanks for your time and reply
yes, its reading properly ..because my application doesn't break while those 370k records are loaded.
if it is so, how to check this and how to fix this ?
no, there no empty fileds text doc is from database. we are sure about this
no missing rows and all missing data is regarded as null
Can you pull directly from the database?
ya i.e is main problem , for some reason ... we are not provided with credentails
I have had a similar problem.
It was solved using the solution proposed here : http://community.qlik.com/message/189249#189249