Load files from multiple folders within a directory

Tue, 26 Feb 2013 10:31:51 GMT

Good day

I'm trying to import Excel files from a number of folders within a directory structure. Each folder only contains one file per customer.

Within Family Packs I have a folder per customer which contains my Excel file that I need to load.

Exmaple Folder structure is as follows:

Parent Folder : D:\QlikView\QVDocuments\Stonehage\FamilyPacks

Client Folder 1 : D:\QlikView\QVDocuments\Stonehage\FamilyPacks\Kirsh

Client File : Kirsh.xlsm

Client Folder 2 : D:\QlikView\QVDocuments\Stonehage\FamilyPacks\Douglas

Client File : Douglas.xlsm

I'm not to sure where I'm going wrong, I have tried to view other forum posts but have not come right yet.

I have tried a number of options but have left the last two attemps in the document attached with the error I'm getting.

Any help will be greatly appreciated.

Re: Load files from multiple folders within a directory

Gysbert_Wassenaar — Tue, 26 Feb 2013 11:22:06 GMT

Looks like your file names contain special characters like brackets and/or paretheses. Make sure the file name is enclosed in square brackets in the load statement. See here for example

Re: Load files from multiple folders within a directory

Mon, 04 Mar 2013 13:17:56 GMT

Thanks for the help worked perfectly.

topic Re: Load files from multiple folders within a directory in QlikView

Load files from multiple folders within a directory

Re: Load files from multiple folders within a directory

Re: Load files from multiple folders within a directory