Loading Trailing Spaces from DataBase

[#1]

Hi Folks, I am stuck with one problem. I am loading the data from Oracle Database and one filed have Trailing Spaces (Ex: Name = 'John '). I need to load the Trailing Spaces from Database. But Qlikview discard the Trailing Spaces from Database.

Is there any property need to turn on / off to load the Trailing Spaces?

Please help on this.

Thanks,

Siri

[hic · Accepted solution]

Add the command

     set Verbatim = 1;

before you load the data from the DB. This prevents QlikView from stripping blanks.

HIC

PS If you're unlucky, the ODBC does the stripping, and then there is nothing that QlikView can do...