Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Thanks for the help worked perfectly.