Problem in Loading Data from Sub-directories

Fri, 24 Apr 2015 05:47:51 GMT

Anyone please help me in with below QV Code, I am not able to load files from Sub-directories..

set Concatenate=;

sub ScanFolder(Root)
for each Ext in '.xls' // use this to identify file names to load but I can't use the wildcard to pull all File1*
for each FoundFile in filelist(Root & '\*.' & xls)
FileList:
$(Concatenate)
load *
from [$(FoundFile)](biff, embedded labels, header is 2 lines, table is [$(*)]); // my load has different parameters depending on the file name.

set Concatenate = concatenate;
next FoundFile
next Ext

for each SubDirectory in dirlist(Root&'\*')
call ScanFolder(SubDirectory)
next SubDirectory
end Sub

Call ScanFolder('D:\Data\Inputs');

Re: Problem in Loading Data from Sub-directories

Anonymous — Mon, 27 Apr 2015 02:50:35 GMT

Hi Narsingh,

Please refer to this thread Loop through root directory (including subfolders) and list filenames of *.csv, maybe this solution can be helpful for you.

Regards,

Karla

topic Re: Problem in Loading Data from Sub-directories in QlikView

Problem in Loading Data from Sub-directories

Re: Problem in Loading Data from Sub-directories