XML Parse - embedded XML - example attached

otherguy — Sat, 16 Nov 2024 18:56:02 GMT

Hi,

I have tried to rebuild the environment i am using by creating the attached sample data. My Client has a MySQL db with embedded XML data, this is one particular part of their environment that i am trying to optimize using Qlik to parse the XML portion rather that a looped SQL Extract statement (it's so slow and almost impossible to incrementally load).

I feel like i'm close to getting this right but i also feel like maybe it is not possible this way due to the structure of this particular XML. I have attached the example and you can see that the data is duplicating after the Generic Load.

I have used the Subfield -> textbetween -> Generic Load -> left join

I know there is also load from_field functionality where you can use xml simple but i am not sure how to parse this particular XML structure using this way:

Any help or previous experience on this would be great!

Thank you!!

Re: XML Parse - embedded XML - example attached

rwunderlich — Tue, 17 Mar 2020 02:06:16 GMT

I usually use the from_field method. I start by taking the field contents and pasting it to a text file. Then use the Table Files wizard to generate the correct xmlsimple script. Finally I replace the "from file.." with

from_field (mytable,myfield)

-Rob

topic Re: XML Parse - embedded XML - example attached in QlikView

XML Parse - embedded XML - example attached

Re: XML Parse - embedded XML - example attached