Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
antonaks
Creator II
Creator II

Null values after load from Postgres DB

Hello colleagues! 

I'm asking for help. I load data from Postgres DB to Qlik Sense, from 1 table (use common Postgres connector). All rows are fetched well, but my result is not matching with original table, because some columns have empty values. 

Original table has 478 000 rows and 47 columns. I don't use any filters or other manipulations, only load data. 

Why can that happens? 

 

Example:

Capture.PNG

Labels (2)
1 Solution

Accepted Solutions
antonaks
Creator II
Creator II
Author

I fixed issue with ODBC Postgress connector. 

View solution in original post

2 Replies
antonaks
Creator II
Creator II
Author

I fixed issue with ODBC Postgress connector. 

View solution in original post

frank_dehner
Contributor II
Contributor II

Hi,

I am facing the same issue when I access a PostgreSQL database. Some of the fields are empty (null), some not. It differs when I am using select * from table; or when I am calling select a,b,c from table;. For first query I always get nulls, for last query I get nulls only for some fields.

What's wrong? What was the connector issue problem?