Fixed length ID number

[REjaz1662272866]

How to generate a fix sized number: "SN-0001...SN-1000"? Please help!!

[Anonymous · Accepted solution]

Hi

try this expression on tMap or tJavaRow, it will generate a fixed sized number for each row.

"SN-"+String.format("%04d", Numeric.sequence("s1",1,1))

Regards

Shong