topic String Sequence in Talend Studio https://community.qlik.com/t5/Talend-Studio/String-Sequence/m-p/2243533#M29983 <P>Hi ,</P><P>I need to generate a id column having string data type like :</P><P>TM_00001</P><P>TM_00002</P><P>...</P><P>and so on.</P><P>So, what could I do to achieve this?</P> Thu, 07 Nov 2019 13:05:08 GMT Prakhar1 2019-11-07T13:05:08Z String Sequence https://community.qlik.com/t5/Talend-Studio/String-Sequence/m-p/2243533#M29983 <P>Hi ,</P><P>I need to generate a id column having string data type like :</P><P>TM_00001</P><P>TM_00002</P><P>...</P><P>and so on.</P><P>So, what could I do to achieve this?</P> Thu, 07 Nov 2019 13:05:08 GMT https://community.qlik.com/t5/Talend-Studio/String-Sequence/m-p/2243533#M29983 Prakhar1 2019-11-07T13:05:08Z Re: String Sequence https://community.qlik.com/t5/Talend-Studio/String-Sequence/m-p/2243534#M29984 <P><A href="https://community.qlik.com/s/profile/0053p000007LQCAAA4">@Prakhar</A>&nbsp;,use the below syntax in tmap or tjavarow to generate sequence.</P> <P>&nbsp;</P> <P><SPAN>"TM_"+StringHandling.LPAD(Numeric.sequence("S1", 1, 1).to String(),5,"0")</SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 07 Nov 2019 16:28:50 GMT https://community.qlik.com/t5/Talend-Studio/String-Sequence/m-p/2243534#M29984 manodwhb 2019-11-07T16:28:50Z