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

[menta]

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?

[menta]

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?

[rwunderlich]

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

[menta]

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