Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My text field has a maximum size of 255 characters when loading into qlik's memory. The same field loaded in pgadmin has a longer length.
I solved the problem.
For some reason, when the column is of type TEXT, the qlik LOAD only loads 255 characters.
By changing the type to CHARACTER VARYING(1000), the LOAD loads the complete string
I solved the problem.
For some reason, when the column is of type TEXT, the qlik LOAD only loads 255 characters.
By changing the type to CHARACTER VARYING(1000), the LOAD loads the complete string
In addition to this solution, the following tip might also be helpful in this context when it's about
"extracting data from TEXT columns having much more than 1000 or 16384 characters inside":
so short
Stefan
You saved my life, I had the same issue with the same use case (polyline geometries), works as a charm