Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Peony
Contributor

Scrip to calculate timestamp for loading objects

Hi all.

In the data load window I may see tables that are loading in my app and how much rows they are contained.
I need to create an additional part of the script in the app that may save date and time whan each table start and end loading. 
It should be table like 
Tablename|Start load                     |EndLoad
Table 1        |2019/11/02 10:09:35|2019/11/02 10:13:30

How I may do it?


1 Solution

Accepted Solutions
y_grynechko
Contributor II

Re: Scrip to calculate timestamp for loading objects

Hey,


LET v_ReloadStart = Now();
LET v_TableName= 'Temp';

$(v_TableName):
LOAD *
Inline [
vProfileB12,ArrayValues
A,1;2;3;4;5;6;7;8;9;10;11;12;13;14;15];


LET v_ReloadEnd = Now();


Meta:
Load
'$(v_TableName)' as TableName,
'$(v_ReloadStart)' as ReloadStart,
'$(v_ReloadEnd)' as ReloadEnd
AutoGenerate 1
;


STORE Meta into lib://Desktop/\Meta.qvd (qvd);

View solution in original post

2 Replies
y_grynechko
Contributor II

Re: Scrip to calculate timestamp for loading objects

Hey,


LET v_ReloadStart = Now();
LET v_TableName= 'Temp';

$(v_TableName):
LOAD *
Inline [
vProfileB12,ArrayValues
A,1;2;3;4;5;6;7;8;9;10;11;12;13;14;15];


LET v_ReloadEnd = Now();


Meta:
Load
'$(v_TableName)' as TableName,
'$(v_ReloadStart)' as ReloadStart,
'$(v_ReloadEnd)' as ReloadEnd
AutoGenerate 1
;


STORE Meta into lib://Desktop/\Meta.qvd (qvd);

View solution in original post

Peony
Contributor

Re: Scrip to calculate timestamp for loading objects

Brilliant!
Thank you!