Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Valued Contributor II

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

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

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

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