https://community.qlik.com/t5/Talend-Studio/How-to-Auto-Increment-in-tMap/m-p/2255366#M38092 Hi Guys, <BR />Im trying to do something which I think is pretty simple but I cant get it to work. <BR />Ive got for example, ids - a,a,a,a which increments from 1,2,3,4 using Numeric.sequence("s1 ",1,1), this is ok. <BR />However when I move onto ids - b,b,b the increment continues to 5,6,7 while I need it to start from 1 again. Can someone please help? <BR />Thanks, <BR />Adrian Sat, 16 Nov 2024 14:17:47 GMT Anonymous 2024-11-16T14:17:47Z https://community.qlik.com/t5/Talend-Studio/How-to-Auto-Increment-in-tMap/m-p/2255366#M38092 Hi Guys, <BR />Im trying to do something which I think is pretty simple but I cant get it to work. <BR />Ive got for example, ids - a,a,a,a which increments from 1,2,3,4 using Numeric.sequence("s1 ",1,1), this is ok. <BR />However when I move onto ids - b,b,b the increment continues to 5,6,7 while I need it to start from 1 again. Can someone please help? <BR />Thanks, <BR />Adrian Sat, 16 Nov 2024 14:17:47 GMT https://community.qlik.com/t5/Talend-Studio/How-to-Auto-Increment-in-tMap/m-p/2255366#M38092 Anonymous 2024-11-16T14:17:47Z https://community.qlik.com/t5/Talend-Studio/How-to-Auto-Increment-in-tMap/m-p/2255367#M38093 Hello adrianorirl, <BR />Create a variable (var2) with this expression : <BR />Var.var2==0 || Var.var2&gt;=4 ? 1 : Var.var2+1 <BR />I've tested it, it works well. <BR />Regards, <BR />JC Wed, 16 Jul 2008 12:41:49 GMT https://community.qlik.com/t5/Talend-Studio/How-to-Auto-Increment-in-tMap/m-p/2255367#M38093 Anonymous 2008-07-16T12:41:49Z