Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi !
Im trying to create a csv file that store the begin and end of a app process, so i made this example:
TEMPO_EXECUCAO:
LOAD
'$(vReloadStartTime)' as INICIO,
'$(vReloadEndTime)' as FIM,
'$(vReload)' as TEMPO_TRANSCORRIDO,
;
TESTE:
LOAD
INICIO,
FIM,
TEMPO_TRANSCORRIDO
RESIDENT TEMPO_EXECUCAO ;
exit script;
But my TESTE don't recognize TEMPO_EXECUCAO as a table.
Why?
add the bold
load
'a' as INICIO,
'b' as FIM,
'c' as TEMPO_TRANSCORRIDO
AutoGenerate 1
;
Also maybe you need a noconcatenate in the second load
add the bold
load
'a' as INICIO,
'b' as FIM,
'c' as TEMPO_TRANSCORRIDO
AutoGenerate 1
;
Also maybe you need a noconcatenate in the second load
You can do something like below
Let vReloadStartTime = Now();
now load all your tables.. and at the end of script..
Let vReloadEndTime = Now();
Let vReloadTime = Interval($(vReloadEndTime)-$(vReloadStartTime),'hh:mm:ss');
If you want to store them in table..
use as below
ReloadInfo:
Load
'$(vReloadStartTime)' as ReloadStartTime,
'$(vReloadEndTime)' as ReloadEndTime,
'$(vReloadTime)' as TotalReloadTime
Autogeneate 1;
Hi Massimo,
Thank you, it works!
But can you explain to me how works the AutoGenerate?