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 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 database
As I understand connection settings in Qlik is ok, the limitations for string load is quite big – 10 000 symbols.
Connection settings
Do you have any thoughts on that issue? Will be grateful for help