XML Parse - embedded XML - example attached

[otherguy]

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!!

[rwunderlich · Accepted solution]

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