Sequence number generation

[ithirak_17]

Hi All,

I have one clarification in generating the sequence number.

File layout:
12|44
12|43
14|22
14|21
16|29

So depend on the first column if it same number ie 12 i need generate the sequence number from 1 and proceeds further if the first column value changes i need to reset again to 1 to generate the sequence.
Example:
column1 |column2|seqno
12|44|1
12|43|2
14|22|1
14|21|2
16|29|1.

Help me out in solving this issue.

Thanks in advance.

[Sainath.Srinivasan]

Check this thread. Similar and almost identical.

viewtopic.php?t=129330

[ithirak_17]

Thanks a lot it works!!!

Check this thread. Similar and almost identical.

viewtopic.php?t=129330