Filter To Latest Date

[Gareth Horton]

Nicholas

The only way I can think of achieving what you needs does involve a two pass
operation.

Firstly, create a summary of Skill and Effdate as key fields (you do not need a summary field in V5).

In the summary, use a descending sort on the date and choose the suppress duplicate values
option so you get something like this:


APR1/3 7/1/1999
7/1/1998
9/1/1996
APR1/2 7/1/1999
7/1/1998
2/1/1996
APR1/1 7/1/1999
7/1/1998
6/1/1996
APLCNT 7/1/1999
7/1/1998
9/1/1996
AP2/2S 3/1/1997
AP2/1S 7/1/1996
AP1/2S 9/1/1996
A2/5SH 1/1/1997
A1/4SR 7/1/1998
3/23/1998

Then you can export this as a fixed width text file and open it up and create a trap using
the fact that the current values always have a skill field in the report.

This sort of thing is probably best set up as a script.

Gareth Horton
Datawatch

Nicholas Osdale wrote:
> I have a .PRN file with this type of format:
>
> SKILL EFFDATE RATE
> A1/4SR 3/23/1998 14.4500
> A1/4SR 7/1/1998 14.7000
> A2/5SH 1/1/1997 18.6800
> AP1/2S 9/1/1996 10.8500
> AP2/1S 7/1/1996 9.9500
> AP2/2S 3/1/1997 11.7500
> APLCNT 9/1/1996 8.0500
> APLCNT 7/1/1998 8.3000
> APLCNT 7/1/1999 10.0000
> APR1/1 6/1/1996 8.0500
> APR1/1 7/1/1998 8.3000
> APR1/1 7/1/1999 10.0000
> APR1/2 2/1/1996 9.8500
> APR1/2 7/1/1998 10.1000
> APR1/2 7/1/1999 12.0000
> APR1/3 9/1/1996 11.6500
> APR1/3 7/1/1998 11.9000
> APR1/3 7/1/1999 14.0000
>
> I would like to create a filter that will show the current date for each skill:
>
> SKILL EFFDATE RATE
> A1/4SR 7/1/1998 14.7000
> A2/5SH 1/1/1997 18.6800
> AP1/2S 9/1/1996 10.8500
> AP2/2S 3/1/1997 11.7500
> APLCNT 7/1/1999 10.0000
> APR1/1 7/1/1999 10.0000
> APR1/2 7/1/1999 12.0000
> APR1/3 7/1/1999 14.0000
>
> How would this be done?