Need to generate surrogate key from starting when ever group ends

Venkata_Sivaji1 — Sat, 16 Nov 2024 03:11:44 GMT

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!

Re: Need to generate surrogate key from starting when ever group ends

Anonymous — Mon, 24 Feb 2020 03:33:59 GMT

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)

topic Re: Need to generate surrogate key from starting when ever group ends in Talend Studio

Need to generate surrogate key from starting when ever group ends

Re: Need to generate surrogate key from starting when ever group ends