topic Re: Problem in understanding following script !! in QlikView

Problem in understanding following script !!

nikhilgarg — Wed, 31 Dec 2014 05:49:14 GMT

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

Re: Problem in understanding following script !!

alkesh_sharma — Wed, 31 Dec 2014 06:07:58 GMT

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.

Re: Problem in understanding following script !!

sujeetsingh — Wed, 31 Dec 2014 06:26:44 GMT

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

Re: Problem in understanding following script !!

nikhilgarg — Wed, 31 Dec 2014 06:31:28 GMT

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

Re: Problem in understanding following script !!

Wed, 31 Dec 2014 06:35:45 GMT

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

Re: Problem in understanding following script !!

alkesh_sharma — Wed, 31 Dec 2014 06:43:15 GMT

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.

Re: Problem in understanding following script !!

nikhilgarg — Wed, 31 Dec 2014 06:44:51 GMT

HEy,

Plz see the attached script.

Thanks

Re: Problem in understanding following script !!

nikhilgarg — Wed, 31 Dec 2014 06:47:58 GMT

HEy,

THanks Dlamini

Re: Problem in understanding following script !!

alkesh_sharma — Wed, 31 Dec 2014 06:56:10 GMT

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

Re: Problem in understanding following script !!

nikhilgarg — Wed, 31 Dec 2014 07:22:21 GMT

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

Kindly let me know what is it

Thanks

Re: Problem in understanding following script !!

alkesh_sharma — Wed, 31 Dec 2014 07:31:22 GMT

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

Re: Problem in understanding following script !!

SunilChauhan — Wed, 31 Dec 2014 09:58:32 GMT

its data in xml format.

Re: Problem in understanding following script !!

nikhilgarg — Wed, 31 Dec 2014 10:46:59 GMT

Hey,

But what does this denotes ?

Thanks

Re: Problem in understanding following script !!

rwunderlich — Wed, 31 Dec 2014 19:05:39 GMT

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