Hi Folks,

Can you help me with this issue:

I have to generate the numbers say from 1001 for each record in a file based on a key field,
the catch is the generated number should be unique based on key column.
(EMP_NUMBER)

Example:

Input File:
EMP_NUMBER EMP_NAME

8908 SMITH
8100 DAVID
8100 DAVID
8230 MARK
8240 GEORGE
8100 DAVID
8100 DAVID

Output File:

8908 SMITH 1001
8100 DAVID 1002
8100 DAVID 1002
8230 MARK 1003
8240 GEORGE 1004
8100 DAVID 1005
8100 DAVID 1005



Thanks in advance.

S

Hhuh? So adjacent DAVIDs should get the same number but different from another identical bunch of DAVIDs further down in the file? (And what cruel parents gave their children names in all uppercase??)

Actually we have to compare the current record (EMPLOYEE_NUMBER) with the previous records (EMPLOYEE_NUMBER),
If different the seq. number has to be generated otherwise
the number remains same for that record,


Thank you
S

I'm not sure if that was supposed to mean "no, sorry, the example was wrong; they're all the same DAVID" or "yes, sorry, the stuff about unique per key wasn't right actually" but assuming the former, how about

It is actually later:
"yes, sorry, the stuff about unique per key wasn't right actually"

Please find the request:

I have to generate the numbers say from 1001 for each record in a file based on a key field (EMPLOYEE_NUMBER),

we have to compare the current record (EMPLOYEE_NUMBER) with the previous records (EMPLOYEE_NUMBER),
If different the seq. number has to be generated otherwise
the number remains same for that record,


Input File:
EMP_NUMBER EMP_NAME

8908 SMITH
8100 DAVID
8100 DAVID
8230 MARK
8240 GEORGE
8100 DAVID
8100 DAVID

Output File:
Gen_Key
8908 SMITH 1001
8100 DAVID 1002
8100 DAVID 1002
8230 MARK 1003
8240 GEORGE 1004
8100 DAVID 1005
8100 DAVID 1005





Thanks

S

And you are not able to modify the simple awk script you were already given?

I worked great

awk 'BEGIN { n = 100} { if ($1!= prev) { n++ } prev = $1; print $1,$2,n }'

Thanks a lot