Q: does the wild key * work for source file names when they are web files

[#1]

I have several files located on our internal share point site that i'd like to load.  I am able to load each individual file but when i try to load it in one command by using the * key i got the script error msg saying it's bad zip file even though they are Excel xlsx file. 

Examples:

[https://extranet.cenj.net/sites/ILS/Control%20Tower%20Reporting/Qlikview%20-%20MSD%20Reports/MSD20120117.xlsx]

[https://extranet.cenj.net/sites/ILS/Control%20Tower%20Reporting/Qlikview%20-%20MSD%20Reports/MSD20120116.xlsx]

Trying to use:

[https://extranet.cenj.net/sites/ILS/Control%20Tower%20Reporting/Qlikview%20-%20MSD%20Reports/MSD2012*.xlsx]

Can it be done?  Or how to load multiple files in the same directory with common name convention.  Thanks!

(the web path is lengthy and it's actually space where it shows %20)

[swuehl]

No, I don't think you can use a wildcard in querying a web source.

If you know what numbers you want to use, use a for next loop, creating a variable for your URL and use the variable in the load statement.

Hope this helps,

Stefan

[#3]

this approach usually works, if the files are in the same directory (local or on network share).

so, basicly, if one file works, wildcards should be possible.

you could try to eliminate the spaces in the web path. maybe the problem is the https connection, which has to open a new connection for each file, which could lead to timeouts or similar in qv

.

if this is not possible, you could download all files to one folder using Wget (opensource, linux and windows)

istall wget, open cmd and download your files using your wildcard

wget https://extranet.cenj.net/sites/ILS/Control%20Tower%20Reporting/Qlikview%20-%20MSD%20Reports/MSD2012...

http://de.wikipedia.org/wiki/Wget