Skip to main content

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

Trailing and succeeding blank spaces are removed from data during load

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support

Trailing and succeeding blank spaces are removed from data during load

Last Update:

Sep 17, 2020 5:29:02 AM

Updated By:

Sonja_Bauernfeind

Created date:

Apr 16, 2013 8:29:30 AM

Trailing and succeeding blank spaces (ASCII character 32) are removed from data loaded into QlikView.

 

Cause:

QlikView automatically strips data of preceding and succeeding blank spaces by default during load. This behavior is controlled by the system variable verbatim.

See also: SET Verbatim has no effect on Table and Filter pane


Resolution:

 

To avoid QlikView stripping imported data from leading and trailing blank spaces the variable verbatim should be set to 1.


Example:
set Verbatim = 1;

Labels (1)