Opening data from a file with date today

[#1]

Dear all,

how do I get data from a file with date today in it?

For example I would like to open C:\Desktop\test20150421.xlsx in Qlik Sense.

Instead of using the code below, I would like to have something like

FROM [lib://Desktop/test & Date(today(),'YYYYMMDD') & .xlsx] (ooxml, embedded labels, table is Sheet1);

Table1:

Load

    "Class 1",

    "Class 2",

    "Class 3",

    "Class 4"

FROM [lib://Desktop/test20150421.xlsx] (ooxml, embedded labels, table is Sheet1);

Please let me know if you know anything.

[marcus_malinow · Accepted solution]

LET vDateVar = date(today(), 'YYYYMMDD');

Table1:

LOAD

*

FROM

[lib://Desktop/test$(vDateVar).xlsx] (ooxnl, embedded labels, table is Sheet1);

[#3]

Thanks! Managed to do it by using the code

[lib://Desktop/test$(Date(today(),'YYYYMMDD')).xlsx] (ooxnl, embedded labels, table is Sheet1);