Loading Trailing Spaces from DataBase

Mon, 04 Feb 2013 20:05:05 GMT

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

Re: Loading Trailing Spaces from DataBase

hic — Mon, 04 Feb 2013 20:21:36 GMT

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...

topic Loading Trailing Spaces from DataBase in QlikView

Loading Trailing Spaces from DataBase

Re: Loading Trailing Spaces from DataBase