Creating a table

[eduardo_dimperio]

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?

[maxgro · Accepted solution]

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

[MK_QSL]

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;

[eduardo_dimperio]

Hi Massimo,

Thank you, it works!

But can you explain to me how works the AutoGenerate?

[maxgro]

Autogenerate Your Data