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

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

Mon, 10 Apr 2017 08:08:50 GMT

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.

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

rahulpawarb — Mon, 10 Apr 2017 09:07:16 GMT

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

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

Mon, 10 Apr 2017 12:38:04 GMT

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