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')
LOAD
value1,
value2,
value3
FROM [$(File)] (biff, embedded labels); //by leaving the part of naming the table it uses all tables of the file
NEXT File
FOR each Dir in dirlist (Root&'\*')CALL DoDir(Dir)
NEXT Dir
END SUB
CALL DoDir('c:\test')
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).
Thanks.
Jimmy
Hi, Thanks for posting.
thanks in advance for your share.
thanks for the great information.
Kind regards
Piskitta
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.
Thank you,
Nihal
Its not loading multiple sheets from the same file!
Any suggestion?