Need to generate surrogate key from starting when ever group ends

[Venkata_Sivaji1]

Team,

I have input as below.

2016-10-01|1243.5

2016-10-01|1106.8

2017-11-01|12309.0

2017-11-01|13467.9

Output need as :-

date|sales|key_value

2016-10-01|1243.5|1

2016-10-01|1106.8|2

2017-11-01|12309.0|1

2017-11-01|13467.9|2

when ever date change happen, we need to create key from starting.

can some advice how to do it in tmap and tjavarow by using custom coding

Thanks In Advance!

[Anonymous]

Hi
You can call built-in function Numeric.sequence("s1",1,1) to generate a sequence number for each date, eg:
Numeric.sequence(row1.DateColumnWithStringtype,1,1)