Hi, How can I sort and dedupe on multiple columns ?
I have a 5 GB file with 70 columns. I want to sort on four columns f11, f12, f13 and f14. Then I want to dedupe on three columns f11, f12 and f13 so that the minimum value of f14 is retained (that is pick up the first record after sort). Please suggest how to do this. Also, can this be done using rank function? Regards, Abhishek
