Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
eduardo_dimperio
Specialist II
Specialist II

Creating a table

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?

1 Solution

Accepted Solutions
maxgro
MVP
MVP

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

View solution in original post

4 Replies
maxgro
MVP
MVP

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
MVP
MVP

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
Specialist II
Specialist II
Author

Hi Massimo,

Thank you, it works!

But can you explain to me how works the AutoGenerate?