Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Congratulations to the new Qlik Luminary and Partner Ambassador class! Meet them here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
This widget could not be displayed.
1 Solution

Accepted Solutions
RI.qvw
Sample.xlsx

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:

 

Capture.JPG

Any help or previous experience on this would be great!

Thank you!!

Labels (2)
Labels
RI.qvw
Sample.xlsx
‎2020-03-16 05:11 PM

XML Parse - embedded XML - example attached

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:

 

Capture.JPG

Any help or previous experience on this would be great!

Thank you!!

Labels (2)
Labels
RI.qvw
Sample.xlsx
Contributor
Contributor
‎2020-03-16 05:11 PM

XML Parse - embedded XML - example attached

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:

 

Capture.JPG

Any help or previous experience on this would be great!

Thank you!!

Labels (2)
Labels
RI.qvw
Sample.xlsx
Contributor
Contributor
‎2020-03-16 05:11 PM

XML Parse - embedded XML - example attached

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:

 

Capture.JPG

Any help or previous experience on this would be great!

Thank you!!

Labels (2)
Labels
RI.qvw
Sample.xlsx
2,559 Views
0 Likes
2,559 Views
0 Likes
1 Reply
rwunderlich
rwunderlich
MVP
MVP
‎2020-03-16 10:06 PM

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

MVP
MVP
‎2020-03-16 10:06 PM

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

2,538 Views
2,538 Views
otherguy