Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thank you Marcus!