topic Maximum lines for a flat file in QlikView

Maximum lines for a flat file

Tue, 22 Dec 2009 18:19:50 GMT

Is there a maximum of lines for a flat file to get loaded into qlikview?

Because I have a problem with a file of 4milj. lines.
The load always stop after 2053838 lines.

When I try to load some line from the end of the file by filtering the nothing is loaded.
Is it possible that qlikview can't read more then those lines?

Maximum lines for a flat file

prieper — Tue, 22 Dec 2009 18:51:11 GMT

What means "stop"? Is there an error produced, does QV crash or does it not load the entire file? In case of 1 or 2 can imagine that you have not enough RAM. In the third case can it be that there are some hidden ASCII-letters in the file, signalling something weird to QV.

Peter

Maximum lines for a flat file

Tue, 22 Dec 2009 19:03:07 GMT

It just doesn't load the entire file. I don't get any error.

I opened the file with ultra edit to see if there is something wrong in the following record but it seems ok to me.

Maximum lines for a flat file

Tue, 22 Dec 2009 19:38:47 GMT

try Loading A single field from the Whole File justt to make sure the entire file can be read/processed, then add in fields til you hit your problem

Colin R

Maximum lines for a flat file

Tue, 22 Dec 2009 19:50:22 GMT

I already tried this and on the first field I try to load I already have the problem again.
My idea is that the file isn't corrupt. I don't understand why qlikview doesn't load the rest of the file.

Maximum lines for a flat file

Tue, 22 Dec 2009 20:33:43 GMT

If the load always returns exactly the same number of rows, 2053838, try removing the first 10 lines or so.
If you then get 10 less rows in the table, something weird is found on row 2053839.
If you get the same number of rows then the file appears to be ok.
The only thing I can come up with in that case is splitting the file into 2 or more files.
I know that's a poor solution but at least it should work.

/Fredrik

Maximum lines for a flat file

danielrozental — Wed, 23 Dec 2009 00:06:13 GMT

There might be some non readable ascii characters present in your file causing the load to stop, check the row that's giving you problems.