Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
paulcalvet
Partner
Partner

Excelfilename in script editor

Hi,

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 ?

Thanks

1 Solution

Accepted Solutions
paulcalvet
Partner
Partner
Author

Hi i find the answer :

load

subfield(Filename(),'.',1) as [BranchFromFilename],

Results

By

View solution in original post

1 Reply
paulcalvet
Partner
Partner
Author

Hi i find the answer :

load

subfield(Filename(),'.',1) as [BranchFromFilename],

Results

By

View solution in original post