Value changing after importing from data from SQL Server to Qlikview

[rajivmeher]

Hi All

I am trying to pull data from SQL Server to Qlikview using OLEDB connection. However when the data comes to Qlikview the data is changing. Please suggest if I am doing anything wrong or if there is anyway to avoid it.

The values in SQL Server for the column in Question is NULL, 1, 0. When I load it to Qlikview, it changes to -1 and 0.

Please see the screenshots below for reference.

Please suggest.

Regards

Rajiv.

[rajivmeher]

Thanks marcus_sommer‌.

Will give it a try.

Regards

Rajiv.

[vasilev]

Hi rajivmeher,

I have the same problem like you and found a better solution for this one. You could convert the field from boolean into integer directly at the SQL query.

Something like that:

select distinct

CONVERT(int, PORT) PORT

from DIM_SUBSCRIPTIONS

It works.