Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Large number of missing rows

Hi

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?

1 Solution

Accepted Solutions
Not applicable
Author

change the quoting.
Try standard instead of MSQ

View solution in original post

3 Replies
Not applicable
Author

change the quoting.
Try standard instead of MSQ

Not applicable
Author

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.

Not applicable
Author

That did the trick!

Thanks!