Read CLOB data field from db to Qlikviw

[poonam_kulwal]

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

[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]

Thank you Marcus!