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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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