Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
LET vDateVar = date(today(), 'YYYYMMDD');
Table1:
LOAD
*
FROM
[lib://Desktop/test$(vDateVar).xlsx] (ooxnl, embedded labels, table is Sheet1);
LET vDateVar = date(today(), 'YYYYMMDD');
Table1:
LOAD
*
FROM
[lib://Desktop/test$(vDateVar).xlsx] (ooxnl, embedded labels, table is Sheet1);
Thanks! Managed to do it by using the code
[lib://Desktop/test$(Date(today(),'YYYYMMDD')).xlsx] (ooxnl, embedded labels, table is Sheet1);