Evaluate '$(Now())' in Inline Load

[JustinDallas]

Hello Folks,

How on earth do I get this to work?

LastLoad:
Load * Inline
[
TimeOfLastLoad
    '$(Now())'
]
;

I just want to load a single row, single column table with the result of Now().  But it's not working.

[sunny_talwar · Accepted solution]

May be this

LastLoad: 

LOAD Evaluate(TimeOfLastLoad) as TimeOfLastLoad;

Load * Inline 

[ 

TimeOfLastLoad 

    'Now()' 

] 

;

[JustinDallas]

You cheated, I'm not sure how, but I'm sure you did.  I could have sworn I tried that during my "Shotgun Method" (where you try everything under the sun) debug session

[sunny_talwar]

Cheated from where .... The other way to do this is to do something like this

LET vTimeOfLastLoad = Now();

LastLoad:

LOAD '$(vTimeOfLastLoad)' as TimeOfLastLoad

AutoGenerate 1;