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?
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.
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.
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.
