Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Loading a long field to a qvd from oracle

Hi...

I need to load a table that has a long field from oracle.

In the database, I can set the long dimension prior to the select.

Is there a way to load the data in qlik using only the select statement??

Thanks.

Tags (3)
3 Replies
mov
Esteemed Contributor III

Re: Loading a long field to a qvd from oracle

Gonzalo,

Typically, whatever query works in database, can be used in QV script.

I had some problems with the long fields, although it wasn't Oracle.  Used this:

QV_Table:

LOAD

...

NotesPart1 & NotesPart2 & NotesPart3 & NotesPart4 as FullNotes,

...

;

SQL SELECT

...

substring(LONGNOTES,1, 8000) as NotesPart1,

substring(LONGNOTES,8001, 16000) as NotesPart2,

substring(LONGNOTES,16001, 24000) as NotesPart3,

substring(LONGNOTES,24001, 32000) as NotesPart4,

...

FROM Database.Table;

Not applicable

Re: Loading a long field to a qvd from oracle

I'm not sure what's exactly your problem, but you can convert LONG to CLOB using TO_LOB(). Once column is a CLOB you can do virtually everthing you may need using dbms_lob package

Lukasz

Not applicable

Re: Loading a long field to a qvd from oracle

Thanks Michael for the suggestion,  that worked for me, although it does have a fixed limit depending on how many chunks we query for that we will have to be aware of.

I had the problem of trying to query a table where one of the fields was a CLOB containing around 5000 characters of text defining a long list of properties. When loaded into Qlikview this large field was being truncated and I only had the fist 4k  (4096) chars of text in the Qlikview field and many of the properties were not being loaded.

Thanks Dave.