Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
paul_scotchford
Specialist
Specialist

Extracting Oracle CLOB rows

Hi and thanks in advance and much appreciated for any responses...

I am currently looking at extraction of CLOB rows from an Oracle database, has anyone done this effectively or is it a too hard basket for QlikView loads?

The Scenario ...

1 CLOB field, the CLOB field may contain 4 (or more) Attributes at the start of the string, followed by a set of values for the attributes, these value will chain for the length of the data being stored (just looks like one long comma separated cell value when exported to excel).

So my question is, has anyone done any work with CLOBS and slicing up the contents ? I'm a newbie with CLOB stored data.

Any recommendations would be welcomed.

Best

Paul


Sensitive data hence I cannot post a sample, apologies.

Example (when hovering over the loaded CLOB field in QV)

Field1, Field2, Field3, Field4

Value1,Value2,Value3,Value4

Value1,Value2,Value3,Value4

Value1,Value2,Value3,Value4

Value1,Value2,Value3,Value4

... and so on for thousands of chains of attribute values.

Example (when exported to excel - single large column, note no comma between last attribute and first value)

Field1, Field2, Field3, Field4Value1,Value2,Value3,Value4,Value1,Value2,Value3,Value4,Value1,Value2,Value3,Value4...

0 Replies