Discussion Board for collaboration related to QlikView App Development.
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.
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
View solution in original post
Thanks for the help worked perfectly.