Subject: | |
From: | |
Reply To: | Newton, Ernie |
Date: | Thu, 26 Jun 2008 16:01:33 -0700 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
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 *
|
|
|