2 Replies Latest reply: Apr 10, 2017 8:38 AM by Deepika Shinde RSS

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

    Deepika Shinde



      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.




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


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



      Data sample"








      Please help.