Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
wadesims
Contributor III
Contributor III

Cell contents trimmed of leading spaces

I have a table which I am importing which contains leading spaces in some of the fields. I desire to retain these leading spaces for the purposes of formatting, but when I perform the following load, the leading spaces appear to be stripped from the fields in question.

The load statement follows reading from a SQL Server table:

GLReportLines:
SQL SELECT *
FROM dbo.qvGLReportLines;

Is there an option that I need to set to retain leading spaces?

- Wade Sims

0 Replies