Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

eduardo_dimperi
Valued Contributor 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
MVP
MVP

Re: Creating a table

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

4 Replies
MVP
MVP

Re: Creating a table

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

Re: Creating a table

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_dimperi
Valued Contributor II

Re: Creating a table

Hi Massimo,

Thank you, it works!

But can you explain to me how works the AutoGenerate?

MVP
MVP

Re: Creating a table

Community Browser