Let me try to state this more simply. I want to find duplicate records based upon the field SVOTERID1 and combine the values for each field into one record. If there is no value in the field for the newest record as determined by field RDATE 1 the value from any iteration of the record would populate the field; if there is a value in the field for multiple iterations, then the newest record determines the value for the field.
Could this help someone write a script for me?
You could try something like this:
1. Backup your file.
2. Sort your records by SVOTERID1 and RDATE1, descending, so that the newest record is the first one in each pair.
3. Click in the field you want to process, say CTY, and select Replace Field Contents... with the following calculation:
Mod ( Get ( RecordNumber ) ; 2 ) and IsEmpty ( CTY ) ;
GetNthRecord ( CTY ; Get ( RecordNumber ) + 1 ) ;
4. Repeat step 4 for the rest of the fields (don't forget to change the references to the currently processed field).
5. Export your records, grouped by SVOTERID1.