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

QV loads only 20% of data from a txt

Dear all,

I really don' t know where to look at anymore.

I have a series of txt files (monthly orders line) that are loading fine.

This one instead, is loading only ~30k lines out of a total of ~147k lines.

Excel loads all the line, Access loads all the lines, QV not.

I really don't know what is wrong. I also checked in Excel if there were duplicated rows, but I could find only 200, so a negligible amount.

I know it is a long shot, but do you have any idea why this could possibly happen??

thank you so much!

stupid oracle.JPG.jpg

12 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Consider a comma separated file. If one of the fields contains a comma as data, the field is surrounded by quotes to escape the comma and keep it from being treated as delimiter. The MSQ parameter tells QV to look for this kind of quoting -- and to remove the quotes from the field.

-Rob

Not applicable
Author

Thanks for your reply.

So, referring to your example above, if I am to REMOVE the MSQ parameter, I would get a field value surrounded by quotes in my final extracted data?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Yes, but only if the field was originally written with quotes.

-Rob