Discussion Board for collaboration related to QlikView App Development.
I want to extract and store the excel file name from many Excel Files wich are in a folder.
DIRECTORY '$(vs_Source_Data)\budget'; FOR EACH ExcelFile in FileList('*2013_09*.xls') BUDGET: Load KeepChar(left(@2,18),'0123456789') as Compte, @3 as Budget_2013 $(ExcelFile) as Dossier,FROM $(ExcelFile)(biff, no labels, header is 6 lines, table is [Controle DC 200$]);NEXT ExcelFile;
There is an error on the Excel File in the load section and i can't use this variable.
Do you know how to use this filename in the load section ?
Hi i find the answer :
subfield(Filename(),'.',1) as [BranchFromFilename],
View solution in original post