topic Log run times in DataLoad Editor in QlikView

Log run times in DataLoad Editor

nvrphanikumar — Mon, 13 Mar 2017 21:25:19 GMT

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) ;

maxgro — Mon, 13 Mar 2017 22:07:10 GMT

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 — Tue, 14 Mar 2017 13:12:15 GMT

Thanks You...Trace did the trick