topic Re: Looping Through Folders in QlikView

Looping Through Folders

Berg_127 — Mon, 05 Sep 2022 11:20:43 GMT

Hi There,

I am not that advanced in QlikView coding and require assistance with the following:

I have about 100 folders containing Client quotations. Some of these folders contain sub-folders and those sub-folders contain updated versions of a quotation.

I need to create a report that extracts the quote values from the various quotes located in each folder. Instead of going through each folder and sub-folder, I require a script that loops through all folders and sub-folders and extracts the quote value and client name from the file (Excel file).

Is this something that can be done via QlikView?

Many thanks.

Re: Looping Through Folders

Aurelien_Martinez — Mon, 05 Sep 2022 12:13:52 GMT

Hi,

You can use a recursive function like :

sub subFolder(folder) TRACE $(folder); FOR Each vFile in FileList('$(folder)\*') TRACE $(vFile); //Load your files NEXT FOR Each vFolder in DirList('$(folder)\*') TRACE $(vFolder); CALL subFolder('$(vFolder)'); next vFolder ENDSUB CALL subFolder('C:\Data\000_Admin');

Re: Looping Through Folders

MarcoWedel — Mon, 05 Sep 2022 16:00:11 GMT

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptControlStatements/For%20Each.htm#:~:text=This%20example%20loads%20a%20list%20of%20all%20QlikView%20related%20files%20in%20a%20folder.