topic Re: how to extract fields from an XML DataBase with QV in QlikView

how to extract fields from an XML DataBase with QV

GartoJsar — Wed, 27 Dec 2017 02:06:00 GMT

Hello everyone,

I need your help,

I am making a connection to a DWH and I am extracting the table "CERTIFICATES", then this table has a field called "CERTIFICADOS_XML" and this field has an XML in text, so what I need is to load the field "CERTIFICADOS_XML" but I need to load only the fields that the xml has with its records.

So I really have no idea how to convert that xml into a table

please, I do not know how to do it.

I leave you an XML image that brings the field CERTIFICADOS_XML

Help!!

And when I load the field CERTIFICADOS_XML in QlikView to if it shows it as in the image below

Re: how to extract fields from an XML DataBase with QV

Anil_Babu_Samineni — Wed, 27 Dec 2017 02:34:00 GMT

Map be look TextBetween - script and chart function ‒ QlikView

Re: how to extract fields from an XML DataBase with QV

marcus_sommer — Wed, 27 Dec 2017 12:28:08 GMT

I think his will be helpful: Re: XML in a CLOB

- Marcus

Re: how to extract fields from an XML DataBase with QV

GartoJsar — Tue, 02 Jan 2018 17:16:32 GMT

Hello Anilbabu and Marcus Summer,

Thank you very much for your time, I have not been able to solve the issue of extracting fields from xml.

I try to put the TextBetween function, but it does not show any of the fields or maybe I'm not getting the code right, do not have an example where I can only show the xml fields?

Thank you so much

For your time

Re: how to extract fields from an XML DataBase with QV

Anil_Babu_Samineni — Tue, 02 Jan 2018 18:31:07 GMT

Can you make it simpler and result set you want to see?

Re: how to extract fields from an XML DataBase with QV

marcus_sommer — Wed, 03 Jan 2018 08:15:31 GMT

Did you try an approach like this one: Check XML structure for errors before importing?

- Marcus