Most Recent record from a sequential file

Ambuj743 · Post by **Ambuj743** » Sat Mar 04, 2006 1:05 am

I have duplicate data in a sequential file. There is a timestamp field in the sequential file. I want to extract most recent data from the sequential file based on the time stamp.

kcshankar · Post by **kcshankar** » Sat Mar 04, 2006 1:43 am

Hi,
There are many ways.
One of them is by using SecondsSinceFromTimestamp
Try to get minimun(Timestamp difference between given date and sysdate).

regards
kcs

kumar_s · Post by **kumar_s** » Sat Mar 04, 2006 3:20 am

Use Sort stage.
Use two key in Sort stage, 1. Some unique field or ID, 2. Timestamp (Descending).
Retain first.