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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
poonam_kulwal
Partner - Creator
Partner - Creator

Read CLOB data field from db to Qlikviw

Hi All,

I want to read two columns RequestID and Request_Log  from Request table form database.

RequestID a int (PK)

Request_Log as CLOB

When I read these two fields in qlikview and try to display it in table box, I get Request_Log as blank but when I hoover over it, I can see the data.

Any idea, how to extract Request_Log of data type CLOB from database to qlikview file and store it in qvd?

Appreciate your help.

Regards,

Poonam

2 Replies
marcus_sommer

This sounds that the data are there but they contain some linebreaks so that you don't see the data within the first line. This means you could enable n multi-lines in your tables and/or you removes all or maybe doubled linebreaks during the load, maybe with: replace(FIELD, chr(10), ' ') or something similar depending of the kind of linebreaks within your data.

- Marcus

poonam_kulwal
Partner - Creator
Partner - Creator
Author

Thank you Marcus!