
Digital Support
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Trailing and succeeding blank spaces are removed from data during load
Last Update:
Sep 17, 2020 5:29:02 AM
Updated By:
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;
892 Views