Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

While importing XML :error:Semi colon character was expected error ,Faced

Hi,

I am trying to import XML file through URLbut I am facing below error

"A semi colon character was expected."

In the data there is "&" and hence facing above error.

I tried replacing "&" with "&amp" and then import in table.but this didn't solve the issue.

Code:

LOAD Replace(key,"&","&amp") as key,

    content

FROM [https://xyz.net/test-initialload_FIR/tasks?amount=20] (XmlSimple, Table is [Root/tasks]);

Data sample"

<tasks>

     <task>

          <key>documents/de/oxx?mmsArtNo=333993&ampvariantNo=1&ampbundleNo=1&amplanguage=de</key>

          <content>INSERT</content>

     </task>

</tasks>

Please help.

2 Replies
rahulpawarb
Specialist III
Specialist III

Hello Deepika,

Trust that you are doing great!

To solve this issue you have to correct the xml file before loading into QlikView application (refer below draft version of xml file):

<tasks>

     <task>

          <key>documents/de/oxx?mmsArtNo=333993&amp;variantNo=1&amp;bundleNo=1&amp;language=de</key>

          <content>INSERT</content>

     </task>

</tasks>

Hope this will be helpful.

P.S.: Place a semicolon after &amp.

Regards!

Rahul

Not applicable
Author

Hello Rahul,

Thank you for the reply.

I tried replacing & to &amp ,but still I faced an issue.

Now I updated the .xml file ,using Macro,replacing "&" with "ampersand" and then import in Qlik.

While importing xml ,i replace "ampersand" back to "&" and then I got the data in table.

Regards,

Deepika