String Sequence

[Prakhar1]

Hi ,

I need to generate a id column having string data type like :

TM_00001

TM_00002

...

and so on.

So, what could I do to achieve this?

[manodwhb · Accepted solution]

@Prakhar ,use the below syntax in tmap or tjavarow to generate sequence.

"TM_"+StringHandling.LPAD(Numeric.sequence("S1", 1, 1).to String(),5,"0")