load table name keeps changing

[HAmzehAF]

hello, 

i wanna load from excel but the name of the excel keeps changing, i want a way for qlik to take the last date excel and load it cuz im doing a history for this qvd that im saving the daily sales from this excel 

any ideas on how to do it ?

[MayilVahanan]

Hi

Try like below

Solved: Load the latest file of a folder - Qlik Community - 192461

[Cascader]

try this:

LET vFolderPath = 'C:\Your\Excel\Directory\';

TempFileList:

LOAD FileName() as FileName, FileTime() as FileTime FROM [$(vFolderPath)*.xlsx]

(ooxml, no labels, table is [Sheet1]);

LET vLatestFile = Peek('FileName', 0, 'TempFileList');

LOAD * FROM [$(vFolderPath)$(vLatestFile)] (ooxml, embedded labels, table is [Sheet1]);