how to do this

harikumar · Post by **harikumar** » Mon Jun 28, 2010 8:18 am

i have source file like
empno,ename
10, aa
20, dd
30, bb
10, cc
40, kk
30, jj

i want to target like this
empno,ename,column
10, aa 2
20, dd 1
30, bb 2
10, cc 2
40, kk 1
30, jj 2

anbu · Post by **anbu** » Mon Jun 28, 2010 8:24 am

How do you calculate column? Is it based on Empno?

harikumar · Post by **harikumar** » Mon Jun 28, 2010 8:29 am

anbu wrote:How do you calculate column? Is it based on Empno?

requirement like that
i have also same doubt

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Jun 28, 2010 8:52 am

harikumar wrote:
anbu wrote:How do you calculate column? Is it based on Empno?

requirement like that
i have also same doubt

In that case you need to be asking the person who gave you that requirement and not this forum members.

Btw, the third column appears to be the number of times the first column has appeared in your input.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 28, 2010 3:29 pm

This is a classic fork-join design. Search for "fork join".