Question

[Dabad]

Hi Guys,

I have 3 excel files that i upload to my application in different time.

First file for example was 5,6,7 than second file was 1,2,3 and than 8,9,10

My client wants that i show to him order of data by time when i uploaded this excel files.

I tried with function ReloadTime () but it doesn't work.

It changed all my reload time to be the same when was last upload.

Could you please tell me how i can do that ?

i need order to be 5,6,7 than 1,2,3 than 8,9,10

Thanks.

Simple example: 

[PrashantSangle]

where you are doing this? in extractor or in final dashboard?

if you just want to sort the files as per their upload? then assuming if you are uploading those file as file creation/ modification date & time stamp then you can use filetime() also.

if this not case then while creating qvd you have to maintain one more field for upload time by using reloadtime() and using incremental load concept you can achieve you requirement.

I hope you got the logic.

Regards,

Prashant Sangle