https://community.qlik.com/t5/Talend-Studio/Fixed-length-ID-number/m-p/2320910#M91000 <P>Hi </P><P>try this expression on tMap or tJavaRow, it will generate a fixed sized number for each row.</P><P>"SN-"+String.format("%04d", Numeric.sequence("s1",1,1))</P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Sun, 04 Sep 2022 12:50:50 GMT Anonymous 2022-09-04T12:50:50Z https://community.qlik.com/t5/Talend-Studio/Fixed-length-ID-number/m-p/2320909#M90999 <P>How to generate a fix sized number: "SN-0001...SN-1000"? Please help!!</P> Fri, 15 Nov 2024 22:35:34 GMT https://community.qlik.com/t5/Talend-Studio/Fixed-length-ID-number/m-p/2320909#M90999 REjaz1662272866 2024-11-15T22:35:34Z https://community.qlik.com/t5/Talend-Studio/Fixed-length-ID-number/m-p/2320910#M91000 <P>Hi </P><P>try this expression on tMap or tJavaRow, it will generate a fixed sized number for each row.</P><P>"SN-"+String.format("%04d", Numeric.sequence("s1",1,1))</P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Sun, 04 Sep 2022 12:50:50 GMT https://community.qlik.com/t5/Talend-Studio/Fixed-length-ID-number/m-p/2320910#M91000 Anonymous 2022-09-04T12:50:50Z