Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Loading Trailing Spaces from DataBase

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

Tags (2)
1 Solution

Accepted Solutions
Employee
Employee

Re: Loading Trailing Spaces from DataBase

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

1 Reply
Employee
Employee

Re: Loading Trailing Spaces from DataBase

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

Community Browser