How to load CLOB oracle file into Spotfire

[Alexandre Rouchouze]

Hello,

I have an Oracle database that contain CLOB data. This CLOB object is a csv-like text that I want to retrieve.

What I have is like:

id   document

1    <CLOB1>

2    <CLOB2>

3    <CLOB3>

And the CLOB are like:

item1|item2|item3

value11|value12|value13

value12|value22|value23

value31|value32|value33

What I want is to get a Spotfire table that contain the different items present into the CLOBs (one line for each entry, one column for each column of the CLOB), with the id (duplicated for each line of the CLOB).

I use Spotfire 10.10.9 LTS.

How can I achieve this?

Thanks

[David Boot-Olazabal]

Hi Alexandre,

 

The CLOB is supported in Spotfire, it is being mapped as a string (see also https://docs.tibco.com/pub/sfire-analyst/10.10.6/doc/html/en-US/TIB_sfire-analyst_UsersGuide/connectors/oracle/oracle_data_types.htm).

When the complete string is imported, you probably need to transform that into the structure that you want. This transformation part can be done in Spotfire's Data Canvas.

Kind regards,

David