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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!