Skip to main content

Announcements
Week 3: High-Volume Iceberg Ingestion and Smarter Data Prep - WATCH NOW

Reading a TXT file into QlikView or Qlik Sense does not load all records and rows due to MSQ Standard

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Joseph_Musekura
Support

Reading a TXT file into QlikView or Qlik Sense does not load all records and rows due to MSQ Standard

Last Update:

Jun 3, 2022 7:08:00 AM

Updated By:

Joseph_Musekura

Created date:

Jun 3, 2022 7:08:00 AM

Reading a text file into QlikView or Qlik Sense does not result in all records being loaded. What can be done to resolve this?

 

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 resolve the problem.

 

 

Environment

Labels (1)
Comments
Amit
Contributor III

"By removing MSQ from the load statement, every row will be loaded." >> Perfect! Thanks!