Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Adamauskas
Contributor
Contributor

Qlik trims values loaded from Postgresql

Hello,

I am new to Qlik and having quite strange issue issue.

I am trying to load some field from Postgresql Database.

LIB CONNECT TO 'Euroglass Odoo';

LOAD name, 
	egd_vin_service_response;

[crm_lead]:
SELECT "name",
	"egd_vin_service_response"
FROM "public"."crm_lead";

The field "egd_vin_service_response" values is about 500 symbols average length, but the Qlik loads only first 249 symbols.

Trimed values after loading from Postgresql DBTrimed values after loading from Postgresql DB

I checked the same connection in Power BI – the data loads without trimming there.

And also I have the quite similar field but from Microsoft SQL Server database, and there is also no trimming during loading to the Qlik:

Values after loading from Microsoft SQL databaseValues after loading from Microsoft SQL database

As I understand connection settings in Qlik is ok, the limitations for string load is quite big – 10 000 symbols.

Connection settingsConnection settings

Do you have any thoughts on that issue? Will be grateful for help

Labels (2)
0 Replies