topic Re: Loading xml file from server to local qvw document in QlikView

Loading xml file from server to local qvw document

Anonymous — Tue, 14 Jun 2016 18:45:31 GMT

Hi Everyone,

I am attempting to load an XML file stored on a server directly into a qvw document saved on my PC.

I have full access to the server and there are not password restrictions on the XML. I am using a load statement in my script similar to:

LOAD field1, field2, field3

FROM [\\server_name\path\file_name.xml] (XmlSimple);

This statement does not produce any errors, however it does not load any data into my qvw document.

When I type in \\server_name\path\file_name.xml into a file explorer window I can access the xml doc just fine. What am I missing that will allow me to load this file?

Thanks in advance.

Michael

Re: Loading xml file from server to local qvw document

muthukumar77 — Wed, 15 Jun 2016 06:09:38 GMT

Hi,

I have tried to load the data from xml. PFA

Please check this app what you are missing.

I'm using "Webfiles" Load.

Re: Loading xml file from server to local qvw document

marcus_sommer — Wed, 15 Jun 2016 07:43:43 GMT

I think the specified file-format isn't quite correct and it is missing the table. The best way to get the syntax right is to use the table-wizard within the script-editor where you could choose xml as file-format to get a preview to the data and the data-structure and maybe an error-message if the xml isn't well-formed.

- Marcus

Re: Loading xml file from server to local qvw document

Anonymous — Fri, 24 Jun 2016 18:55:20 GMT

Thanks Marcus. The wizard was the way to go.

Turns out there was a problem with a key field.