DSXchange

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

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

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

requirement like that
i have also same doubt

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.

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