Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have many folders with their name as date and all of them have an excel file inside them. I have to load all the excel files.
Folder ====> Many Folders named as dates ====> Excel Files
LOAD
FROM
[C:\......\Qlik\Folder\{Regular Expression for date}\*.xlsx]
So im trying to use a regular expression in the load statement to accept all the folders named as date
OR
Im lookin for a logic that will help me to Go inside a folder which is inside a folder.
Something like : [C:\......\Qlik\Folder\*\*.xlsx].........But this doesnt work.
Thankyou in Advance.
Take a look on the second example from:
which provides a possibility to loop with dirlist() and filelist() through multiple folders/files and by using various pattern with the wildcard-chars to the loading files. If your folder/file-logic doesn't completely fit to this rather simple pattern you may add inside further if-loops which check the filename with string-functions like keepchar(), subfield(), index(), mid() and so on to identify the wanted files.
- Marcus