Unable to read all data from CSV file

[Ranganath_DR]

Qlik Sense or QlikView may not load all data from a CSV file.

Resolution

Sometimes a special character is used to mark the end of the file. If this character is found in the middle of a text file (for example, enclosed by quotation marks), the file may not load correctly. In this instance, we can modify how Qlik Sense and QlikView read data. 

Qlik Sense:

1. Select the .csv file you want to load in the File Wizard
2. Set Quoting to None 
3. Check Ignore End-Of-File character? 
   
   
   

QlikView

1. Select the .csv file you want to load in the File Wizard
2. Set Quoting to None 
3. Check Ignore EOF
   
    

Cause

Due to a problem with quotes or special characters in the file. See Help Site File Wizard: Type

Environment

Qlik Sense all supported versions, including Qlik Cloud
QlikView all supported versions