Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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');