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: 
datanerd916
Contributor
Contributor

import large text field

I am importing data into Qlik Sense from a Postgres database.  Some of the attributes I need are stored as a text (variable unlimited length) data type and are coming through as the numeric pointers rather than the actual text.  Is there a way to get Qlik to retrieve and display the actual textual values?

Labels (6)
1 Reply
ArnadoSandoval
Specialist II
Specialist II

Hi @datanerd916 

My suggestion is to modify the query your are using to get the data from the Postgres Database to include a join to the table containing the field description. Another possibility is to bring the table with the description and apply the text with the Qlik's data load script. Perhaps my first suggestion is better.

Hope this helps,

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.