Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rajivmeher
Creator
Creator

Value changing after importing from data from SQL Server to Qlikview

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

QLIKVIEW_OLEDB_SQLSERVER_DISTINCT_PORT.JPG

Please suggest.

Regards

Rajiv.

11 Replies
rajivmeher
Creator
Creator
Author

Thanks marcus_sommer‌.

Will give it a try.

Regards

Rajiv.

vasilev
Creator
Creator

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.