At 07:01 PM 6/26/2008, Newton, Ernie wrote:
Dear Ernie,

get dataset
ext part-number
ext amount-received
ext date-received
sort part-number
sort date-received,desc
dup none keys 1
out some file
xeq

Done.

Note the number at the end of the dup none keys. It say to only look
at the first sort key when deciding duplicates so you can exercise some
control as to the records and help decide what kets thrown away.

So you can specify TWO sort keys but only look at one.

Neil

>Greetings,
>
>Does Suprtool have the ability to give me the newest record?
>
>Here's the make-believe scenario.
>
>My dataset has...
>
>PART-NUMBER
>AMOUNT-RECEIVED
>DATE-RECEIVED
>
>Every time a part is received, it's entered, along with the amount and
>the date it was received.
>
>I want to get the most recent DATE-RECEIVED for each PART-NUMBER
>without regards to AMOUNT.
>
>What I've been doing is extracting everything, sorting it by part number,
>then date, and using Excel to strip all recurring entries.
>
>There's gotta be an easier way.  If I use the above sort, output to a
>self describing file, could I then extract data from that file
>using the DUPLICATE NONE KEYS command to get the most recent entry?
>
>Thanks,
>
>Ernie
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *