Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

Load data from xml files stored into a DB Oracle (Blob Type)

 

Hi all,

I would like to load data from xml files format. the xml files are stored into a table of an Oracle database.

The table is very simple; 2 fields (ID, BLOB).

Any solutions?

 

2 Replies
MVP & Luminary
MVP & Luminary

Re: Load data from xml files stored into a DB Oracle (Blob Type)

1. Get one sample of the xml data and put it in a text file. 

2. Use the script editor wizard to generate the correct load statement to load the xml from the text file. 

3. Load your ID and Xml fields from the database. 

4. Modify your xml load statement to use the from_field() source instead of the text file. 

-Rob

Partner
Partner

Re: Load data from xml files stored into a DB Oracle (Blob Type)

Thank you Rob your Idea is very good but the problem I think is the format of the field in Oracle.

The type is Blob and when I load data in Qlik the field is in a binary format.

I think I need a function to transform the blob into a different format on loading from Oracle