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

[#1]

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.

[rahulpawarb]

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

[#3]

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