Problem in understanding following script !!

[nikhilgarg]

Hey,

TO find reload time of application following script is being suggested. But i don't understand why join and second load is being placed.

----------------------------------------------------------------------------------------------

ReloadTable:

LOAD

'Application2.qvw' as Application,

reloadtime() as ReloadTime

autogenerate(1)

;

join(ReloadTable)

LOAD

[Application],

ReloadTime

FROM C:\QlikView\ReloadTable.qvd (qvd);

store ReloadTable into C:\QlikView\ReloadTable.qvd (qvd);

---------------------------------------------------------------------------------------------------

Kindly help me .

Thanks

[alkesh_sharma]

Hey,

Please find the attached QVW for your reference.

First time it will show error because the QVD doesn't exists. but simultaneous reloads will keep on concatenating 1 extra row on the Old created QVD.

Hope this helps

[SunilChauhan]

its data in xml format.

[nikhilgarg]

Hey,

But what does this denotes ?

Thanks

[rwunderlich]

In addition to the other comments I'd like to point out that "reloadtime()" is the wrong function to use here. ReloadTime() returns the script end time. So in the middle of a script, reloadtime() returns the end time of the previous script execution.

To record the current time, I would suggest using "now(1)" instead.

-Rob

http://masterssummit.com

http://robwunderlich.com