data with spaces in front will auto trim

Mon, 08 Nov 2010 02:52:31 GMT

I have a DB2 db, a column value is '123456789' and another is ' 123456789' where a space in the front. The qv always return me both the same value even i converted to text, replace function also can't detect the "space". How to get the value not to trim?

Thanks.

data with spaces in front will auto trim

Mon, 08 Nov 2010 03:15:07 GMT

I found the solution. set Verbatim=1, explanation from help "Normally all field values are automatically stripped of preceding and succeeding blank characters (ASCII 32) before being loaded into the QlikView database. Setting this variable to 1 suspends the stripping of blank characters."

Next you need to convert the value to string to preserve the space.

topic data with spaces in front will auto trim in QlikView

data with spaces in front will auto trim

data with spaces in front will auto trim