Current row to Next row processing

[pratapsriram]

I have a peculiar scenario. I want to capture the Time taken between two transactions and assign the elapsed time to the first transaction record. I could do this but assign to the next transaction instead of the first one. So if anyone can tell if the other way is possible? Please find the attached screenshot in the below

http://sites.google.com/site/makamsreer ... ow_nextrow

[pandeesh]

Once i had a similar scenario and achieved using stage variables in transformer stage.
By utilizing the power of stage variable to retain the previous value.
I don't think it's a peculiar scenario

[chulett]

You've misread the requirement I'm afraid.

[ray.wurlod]

Other than in the first two rows your example does not appear to be doing what you describe. Can you please clarify? In general DataStage does not have a lookahead capability; you may need to design to update the first row (of each pair?) subsequently.

[Kryt0n]

You can try split and join with row x joining to x+1 and then you have both values on the same line. (Couldn't see your diagram so suggestion not based on anything reflected in that)

Edit: Except you're on server... could've sworn I saw Parallel...

[Kryt0n]

Reverse the order so that the oldest record is last, then use stage variables to hold the newer time.

[pratapsriram]

Reverse the order so that the oldest record is last, then use stage variables to hold the newer time.

Thanks, Yes this is what I did exactly. I ordered in desc order and then processed using stage variables.