Hi . We have a below CSV file and here we need to generate a number in the 1st column based on whether there is duplicates on the 2nd column.
102016,3522850,15,FF,9 104152,3522850,15,FF,7 104152,3522850,15,FF,9 104760,3521499,15,FF,9 104760,3521499,15,FF,9 106735,3507181,15,FF,9 so the o/p need to be as follows 1,102016,3522850,15,FF,9 1,104152,3522850,15,FF,7 2,104152,3522850,15,FF,9 1,104760,3521499,15,FF,9 2,104760,3521499,15,FF,9 1,106735,3507181,15,FF,9 Could someone let me know how this can be achieved in a DFSORT Thanks Ron T ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN