Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I think I missed out something here. The variable I created is not showing at all in my variables tab.
Here is my code.
Dynamic:
LOAD Date as Dyn_Date,
Week as Dyn_Week,
Year as Dyn_Year
FROM
[..\DataSources\ExcelFiles\BookmarkTest\Dynamic.xlsx]
(ooxml, embedded labels, table is Raw);
Let vmaxDate = max(Dyn_Date);
Please help.
Regards,
Darwin
Hi,
You can't do it like that.
You need to do a resident load on the table Dynamic:
Dynamic_MaxDate:
LOAD
max(Dyn_Date) as MaxDate
Resident Dynamic;
then you can peek at the maxdate value.
LET vmaxDate = peek('MaxDate');
And now that we don't need dynamic_MaxDate we drop it:
drop table Dynamic_MaxDate;
Hope it helps.
Regards,
Carlos
Hi,
You can't do it like that.
You need to do a resident load on the table Dynamic:
Dynamic_MaxDate:
LOAD
max(Dyn_Date) as MaxDate
Resident Dynamic;
then you can peek at the maxdate value.
LET vmaxDate = peek('MaxDate');
And now that we don't need dynamic_MaxDate we drop it:
drop table Dynamic_MaxDate;
Hope it helps.
Regards,
Carlos
Try:
Let vmaxDate = '=max(Dyn_Date)';
mwoolf wrote:
Try:
Let vmaxDate = '=max(Dyn_Date)';
mwoolf, this displays the vmaxDate in the Variables tab but not properly evaluating it.
Carlos, i will definitely try it now.
But the thing is, just yesterday, i think i was able to make it work by ticking on some options in Document Properties.