Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Contact
Find Answers
Join Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Get Support
Have a Question?
Search Qlik's Support knowledge database or request assisted support for your highly complex issues.
Submit a Case
Talk with a Representative
Critical Issues
Experiencing a serious product issue? Please Contact us by phone. Click here to view phone numbers and hours by region.
Contact UsWelcome Guest
Installed Qlik Products
My Environments
Log your environments to ensure faster and more targeted troubleshooting.
View Available Licenses
My Licenses
Understand your licenses to help you maximize your experience.
Knowledge
Reading txt file not loading all rows MSQ Standard
Article Number: 000002569 | Last Modified: 2020/03/27Description
When experienced that that all records of text file are not read by QlikView, then what changes need to be applied to make sure that all records are read?
Resolution
If no quotes are to be accepted in the text file, the no quotes specifier should be used. By default, the quotes " " or ' ' can be used, but only if they are the first and last non blank character of a field value.
The no quotes specifier is only relevant for txt files. MSQ indicates that modern style quoting is assumed.
By removing MSQ from the load statement, every row will be loaded.
Changing "Quoting" from MSQ to Standard in the File Import Wizard will also alleviate the problem
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.