topic Re: Null values after load from Postgres DB in Connectivity & Data Prep

Null values after load from Postgres DB

antonaks — Mon, 13 Dec 2021 18:03:38 GMT

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:

Re: Null values after load from Postgres DB

antonaks — Tue, 11 Feb 2020 12:03:22 GMT

I fixed issue with ODBC Postgress connector.

Re: Null values after load from Postgres DB

frank_dehner — Fri, 26 Feb 2021 08:27:45 GMT

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?