Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

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
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)
Contributors
Version history
Last update:
‎2020-09-17 05:29 AM
Updated by: