topic Large number of missing rows in QlikView

Large number of missing rows

Fri, 27 Aug 2010 08:13:44 GMT

I'm loading some fairly sizable data from pipe-dlimited txt files.

The largest file has 3mill rows and loads just fine.

But one of the files with 690k rows ony loads a selection of 317k rows. I cannot figure out what the issue is - it's not simply stopping at a certain point, but actually dropping . ignoring certain rows. If I open the file in excel and save it as .csv then I can load all the rows. So it looks like a potential issue with hidden characters or file format.

Any advice on how to isolate this problem?

Large number of missing rows

Fri, 27 Aug 2010 08:46:51 GMT

change the quoting.
Try standard instead of MSQ

Large number of missing rows

Fri, 27 Aug 2010 08:48:35 GMT

Does it stop at the same row each time? If that is the case, try importing a few lines before and after your problem area to see if the problem is still there. If that's the case the problem is in your input txt-file.

Large number of missing rows

Fri, 27 Aug 2010 09:06:33 GMT

That did the trick!

Thanks!