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
Current row to Next row processing
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 41
- Joined: Tue Jan 24, 2006 3:43 pm
- Location: United States
- Contact:
Current row to Next row processing
Knowledge is Power
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 41
- Joined: Tue Jan 24, 2006 3:43 pm
- Location: United States
- Contact:
Resolved - Please close
Thanks, Yes this is what I did exactly. I ordered in desc order and then processed using stage variables.Kryt0n wrote:Reverse the order so that the oldest record is last, then use stage variables to hold the newer time.
Knowledge is Power