Above function alternate

[#1]

Can anyone suggest alternate to above() function that can be used while loading the qvd. I am using it to calculate time between two status and change of status in text.

It works perfectly in pivot table but as there are 1.7 million distinct object_IDs & 10 million + total rows and i need to do analysis on change of status wise, I need to use calculated data on front hand.

Any suggestions?

[jagan]

Hi Aamir,

Use Previous().

Regards,

Jagan.

[#3]

Well I have already used it but its not working perfectly. Although I have sorted the data correctly. In pivot due to 2 dimensions its working perfectly.

[rbecher]

Hi,

you can use peek() in load script. But the data needs to be ordered anyway.

LOAD OBJECT_ID, 
     UDateTime, 
     Status, 
     [Time Taken in minutes], 
     [Status Changed],
     if(OBJECT_ID=peek('OBJECT_ID'),interval(UDateTime - peek('UDateTime'))) as [Time Delta]
FROM

(ooxml, embedded labels, table is Sheet1);

- Ralf

[Anonymous]

Hi aammir,

             Please find the attachment according to your requirement,please let me know if i did any thing wrong.

Regards

shaik