Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
poonam_kulwal
Partner
Partner

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
MVP & Luminary
MVP & Luminary

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
Partner
Author

Thank you Marcus!