Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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.
Wild cards do not work in the folder names.
Hi! As far as I remember it will not work if the names of the different excel sheets contains space in name. Example below:
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