LET Statement Not Working

[Qvmaster2019]

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

[clisboa_noesis · Accepted solution]

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

[m_woolf]

Try:

Let vmaxDate = '=max(Dyn_Date)';

[Qvmaster2019]

mwoolf wrote:

Try:

Let vmaxDate = '=max(Dyn_Date)';

mwoolf, this displays the vmaxDate in the Variables tab but not properly evaluating it.

[Qvmaster2019]

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.