topic Re: Xml records from the database in QlikView

Xml records from the database

shree909 — Tue, 08 Jan 2013 19:07:37 GMT

Hi,

i have an oracle database with xml data.

with qv i want to extract the xml data and generate qvds and build the front end desgn

but the issue is i am able to connect to the database,

once i select the sql query the window closes

what i know is that the data in the data base is xml so

by using qlikview we can read the xml data or not?

when i am loading the xml data it throws an error which is attached as an image

Re: Xml records from the database

shree909 — Tue, 08 Jan 2013 20:43:16 GMT

Hi can anyone help me on this???????????

Re: Xml records from the database

Thu, 13 Jun 2013 15:12:29 GMT

Did you ever get an answer to this question?

Re: Xml records from the database

Thu, 13 Jun 2013 15:12:40 GMT

Did you ever get an answer to this question?

Re: Xml records from the database

Thu, 13 Jun 2013 15:13:04 GMT

Did you ever get an answer to this question?

Re: Xml records from the database

shree909 — Thu, 13 Jun 2013 15:23:18 GMT

Hi,

i talked to our database team and converted the xml data into normal data like varchar instead of XML ..

Re: Xml records from the database

Thu, 13 Jun 2013 15:28:31 GMT

Thanks for the response, unfortunately I am stuck with xml type.

Re: Xml records from the database

Mon, 23 Sep 2013 13:46:16 GMT

Hello to all.

I am also the problem of extracting information from an Oracle table with column of type XMLType. If anyone has any suggestions please help.

-------------------------------------------------------- Português ---------------------------------------------------------

Olá a todos.

Também estou com este problema de extrair informações de uma tabela Oracle com campo do tipo XMLTYPE. Caso alguém tenha alguma sugestão favor contribuir.

Re: Xml records from the database

Mon, 23 Sep 2013 19:09:18 GMT

Friends, I think I resolved my issue as follows:

In the script created a QlikView QVD:

SQL SELECT extract(XML_DOCUMENTO,'/','xmlns="http://www.portalfiscal.inf.br/cte"').getClobVal() AS XML_DOCUMENTO

FROM XML_DOCUMENTO_FISCAL

This way the files were extracted and can work with the data to make the load of the QVD created.

I hope have helped.

P.S.: Please forgive my English.

---------------------------------------------------------- Português ----------------------------------------------------------

Senhores, acho que resolvi minha questão da seguinte forma:

No script do QlikView criei um QVD:

SQL SELECT extract(XML_DOCUMENTO,'/','xmlns="http://www.portalfiscal.inf.br/cte"').getClobVal() AS XML_DOCUMENTO

FROM XML_DOCUMENTO_FISCAL

Desta forma os arquivos foram extraídos e consigo trabalhar com os dados ao fazer o load do qvd criado.

Espero ter ajudado.