topic "Regular expression for Date in DD-MM-YYY format" OR "Going inside a folder which is inside a folder" in Qlikview in App Development

"Regular expression for Date in DD-MM-YYY format" OR "Going inside a folder which is inside a folder" in Qlikview

Vishal007 — Fri, 27 Aug 2021 08:51:24 GMT

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

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.

Re: "Regular expression for Date in DD-MM-YYY format" OR "Going inside a folder which is inside a folder" in Qlikview

marcus_sommer — Fri, 27 Aug 2021 09:37:15 GMT

Take a look on the second example from:

For each..next ‒ QlikView

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