Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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!