Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load files from multiple folders within a directory

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.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

Not applicable
Author

Thanks for the help worked perfectly.