topic loading any file from sharepoint folder in QlikView

loading any file from sharepoint folder

Wed, 30 Oct 2013 08:15:54 GMT

Hi,

I am trying to load a file from a sharepoint folder. the name of the file can change but the contents will not. I am using the following statement:

...

FROM

[..../Sales%202011/*.xlsx]

(ooxml, embedded labels, header is 1 lines, table is Users);

I get an error back saying there is a error with the name. Is * not allowed in excel files stored on sharepoint? how can i get round this.

thanks.

Re: loading any file from sharepoint folder

fred_s — Wed, 30 Oct 2013 09:20:12 GMT

Hi EAlmeida,

You're allowed to use the * and I don't think Sharepoint is part of your problem.

Could you show the complete Load statement?
It's probably something in your path, square brackets, ...., the %20 escaped space

Re: loading any file from sharepoint folder

Thu, 31 Oct 2013 09:58:53 GMT

Hi fred,

I have tried using it again and if I add the name of the file it loads. If i use * I get an error.

Are the square brackets needed?

Can you post an example of a statement you know does work?

thank,

Re: loading any file from sharepoint folder

fred_s — Thu, 31 Oct 2013 10:12:27 GMT

This works for me:

LOAD *

FROM

(ooxml, embedded labels, table is Blad1);

Re: loading any file from sharepoint folder

jonathandienst — Thu, 31 Oct 2013 10:17:07 GMT

It is not a windows path, it's a URL, and I don't think you can use a wildcard in a URL.

If your sharepoint source is local, then you could find the windows path to the folder containing the files or arrange for a windows share on the folder containing the files. Then you would be able to do a wildcard load.

HTH

Jonathan