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

Reply via email to