I have a file of five fields containing a number of records.
I want to update the value of field 5 on a second record where the second record matches the first record for the first three fields, but where field 4 is the opposite (negative) value of field 4 on the first record.EG:
12345678, 23456, AA, 100.00, XXX
12345678, 23456, AA, -100.00, YYY
I want field 5 on record 2 to be updated to XXX.
Can anyone help?