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]

This works the same way the as concatenating the new rows to old qvd.

You can try yourself and let us know what you didn't understand in this.

[sujeetsingh]

Here it is

ReloadTable:

LOAD

'Application2.qvw' as Application,

reloadtime() as ReloadTime

autogenerate(1)

;

Here the script reload  the application

join(ReloadTable)

LOAD

[Application],

ReloadTime

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

Reloading the information saved to a qvd

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

[nikhilgarg]

HEy,

When i do it by myself , an additional column is generated. Why is it so ? and multiple rows are been shown . Why ??

I have attached the attachment.

Thanks

[#5]

Hi Nikhil

The way I see it, in  the first load statement as you reload your application, its generate one row (autogenerate(1)) and populate it with the name of the application you running and the time at which you are running it, its the moves to the second load statement, there you are loading the metadata of the execution of your application, in the sense that if you ran your application yesterday, the information was stored, so as you are running this application now, your are retrieving previous information from C:\QlikView\ReloadTable.qvd (qvd);concatenate it with the current reloadtime information from ReloadTable you just created, than you are storing this 'updated' information in a qvd file 'store ReloadTable into C:\QlikView\ReloadTable.qvd (qvd);'

Hope this helps.

Kind Regards

Dlamini

[alkesh_sharma]

It should not show an additional column, make sure in both the LOAD statements the the Field names are exactly same

Every time it reloads one more row would be generated an it gets concatenated in the old qvd and 1 row is auto generated when first load statement executes.

[nikhilgarg]

HEy,

Plz see the attached script.

Thanks

[nikhilgarg]

HEy,

THanks Dlamini

[alkesh_sharma]

Pull the data in a tale box and tell me what is the third field coming up?

[nikhilgarg]

I have pulled the data in tableboc and attached the image.

Kindly let me know what is it

Thanks