Breaking News: Grepper is joining You.com. Read the official announcement!

Load latest Excel file

Precious Pheasant answered on May 28, 2021 Popularity 1/10 Helpfulness 1/10

answer Load latest Excel file

Load latest Excel file

Comment

LET vFilePath = 'C:\Qlikview\Data';

FOR EACH file in FileList('$(vFilePath)\*.xlsx');   // Loops each excel file in the given Folder
LET vFileYear =  Left(Right(file, 9), 4);                    // Gets the year portion from the filename
LET vMaxYear = Rangemax(vFileYear, vMaxYear);  // Gets the max year for every iteration
NEXT

Data:
LOAD *
FROM
[$(vFilePath )\Budget $(vMaxYear).xlsx]      // Load Max year data
(ooxml, embedded labels, table is [Sheet1]);

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: community.qlik.com

Tags: excel file load whatever

Link to this answer
Share Copy Link