seqfile

[pandu80]

HI, I HAVE A SEQFILE

1008999999999999999999
1008999999999999999999
1008999999999999999999
2008999999999999999999
2008999999999999999999
2008999999999999999999
2008999999999999999999
3008999999999999999999
3008999999999999999999
3008999999999999999999
3008999999999999999999
3008999999999999999999

IF THE FIRST 3 DIGITS ARE 100 I NEED TO ADD THE SEQNO 001,002...
WHENEVER THE FIRST 3 DIGITS ARE CHANGED I NEED TO SET THE COUNTER AGAIN FROM 1.
MY OUTPUT WILL BE LIKE

001 1008999999999999999999
002 1008999999999999999999
003 1008999999999999999999
001 2008999999999999999999
002 2008999999999999999999
003 2008999999999999999999
004 2008999999999999999999
001 3008999999999999999999
002 3008999999999999999999
003 3008999999999999999999
004 3008999999999999999999
005 3008999999999999999999

PLEASE SHED SOME LIGHT ON THIS.

TIA

[Sainath.Srinivasan]

Set a stage variable

stgSeqNo <- (default) 1
prevKey <- (default) ''

In derivations,

stgSeqNo <- If link.Key <> prevKey Then 1 Else stgSeqNo + 1
prevKey <- link.Key

Please search this forum for similar posts as there are already several posts relating to similar queries.