topic Re: Wildcard in Filepath for folders in QlikView

Wildcard in Filepath for folders

Wed, 25 Sep 2013 13:34:02 GMT

Hi,

is it possible to use a wildcard in the filepath ?

Like R:\data\2013_*\xls\data_*.xlsx

instead of R:\data\2013_08\xls\data_0800.xlsx

this has been discussed before, but only for older builds of QV (As old as 2009 to 2011).

(Loading data from multiple xls-files from folder with subfolder)

Is there a newer, more userfriendly solution to use some kind of wildcard ?

Re: Wildcard in Filepath for folders

gopalopsharma — Wed, 25 Sep 2013 13:59:22 GMT

Hello Alex,

Wildcard works for picking all the files i.e. *.xlsx will work. You just need to use a "For" Loop. We are using this feature in QV 11.

But I have never seen any wild card in the path also. Please try to give it a shot. Let us see what happens. Also please share your observation with the forum.

Re: Wildcard in Filepath for folders

srchilukoori — Wed, 25 Sep 2013 14:01:37 GMT

Wild cards do not work in the folder names.

Re: Wildcard in Filepath for folders

thanstad — Wed, 25 Sep 2013 14:38:16 GMT

Hi! As far as I remember it will not work if the names of the different excel sheets contains space in name. Example below:

Re: Wildcard in Filepath for folders

Thu, 26 Sep 2013 14:31:04 GMT

Wildcards do NOT work, if used like in my example.

The * only works with files so far.

I assumed, since the last posts concerning that problem were from 2011, that there could be another way with the more recent Qikview builds.
I will try something like on the blog and post my findings here:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/09/02/loops-in-the-script