Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
nvrphanikumar
Creator
Creator

Log run times in DataLoad Editor

Hi,

Currently ,My process runs for about 2 hours and I would like to know which steps is taking longer to run.

tried an approach below ,where I declare a variable and then Output that variable as soon as the step is completed.But couldn't get it to work.

LET StartOfScript = Now();

Table_A:

LOAD

*

FROM [lib://QVDS/TABLE_A.qvd](qvd) ;

$(StartOfScript) ;

1 Solution

Accepted Solutions
maxgro
MVP
MVP

LET Start = Now();

//SLEEP 1000;

Table_A: LOAD * ...... ;

LET Elapsed = interval(Now() - '$(Start)');

Trace $(Elapsed);

LET Start = Now();

//SLEEP 3000;

Table_B: LOAD * ...... ;

LET Elapsed = interval(Now() - '$(Start)');

Trace $(Elapsed);

LET Start = Now();

View solution in original post

2 Replies
maxgro
MVP
MVP

LET Start = Now();

//SLEEP 1000;

Table_A: LOAD * ...... ;

LET Elapsed = interval(Now() - '$(Start)');

Trace $(Elapsed);

LET Start = Now();

//SLEEP 3000;

Table_B: LOAD * ...... ;

LET Elapsed = interval(Now() - '$(Start)');

Trace $(Elapsed);

LET Start = Now();

nvrphanikumar
Creator
Creator
Author

Thanks You...Trace did the trick