QlikView documentation and resources.
This is code snippet is able to load a bunch of xls-files with the same data format but with different file-names, even perhaps with different sheet-names and located in a folder with subfolder(s).
It´s based on this thread from the archive. Thanks to the anonymous user. [;)]
SUB DoDir (Root)FOR each File in filelist(Root& '\*.xls')LOADvalue1,value2,value3FROM [$(File)] (biff, embedded labels); //by leaving the part of naming the table it uses all tables of the fileNEXT FileFOR each Dir in dirlist (Root&'\*')CALL DoDir(Dir)NEXT DirEND SUBCALL DoDir('c:\test')
SUB DoDir (Root)
FOR each File in filelist(Root& '\*.xls')
FROM [$(File)] (biff, embedded labels); //by leaving the part of naming the table it uses all tables of the file
FOR each Dir in dirlist (Root&'\*')
By modifying the code you will be able to load mutiple files in other file formats like csv and so on.
Hi, I need help how to load multiple Microsoft Access file (.mdb).
Hi, Thanks for posting.
thanks in advance for your share.
thanks for the great information.
Hi, I am loading the data by your approach BUT in my case I want to add a date field (initially which is not in the table data) all I have a date and time stamp in the file name it self (ex: file_17.04.01_00.15).
Please help me to extract the date and time stamp from the file name and store it into a 'Date' field.
Its not loading multiple sheets from the same file!