topic Re: counter on SubField in QlikView https://community.qlik.com/t5/QlikView/counter-on-SubField/m-p/1438926#M818188 <HTML><HEAD></HEAD><BODY><P>Hi Amien,</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG style="font-size: 10pt;">LOAD</STRONG></SPAN><SPAN style="font-size: 10pt;"> <SPAN style="color: #800000;">Product</SPAN>&amp;' '&amp;<SPAN style="color: #0000ff;">IterNo</SPAN>(), 1 <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">#Counter</SPAN> <SPAN style="color: #0000ff;">Inline</SPAN> <SPAN style="color: #800000;">[<BR /> Product, #Counter<BR /> iPhone X, 3<BR /> Samsung 8, 2<BR /> ]</SPAN><SPAN style="color: #0000ff;">While</SPAN> <SPAN style="color: #0000ff;">Iterno</SPAN>() &lt;= <SPAN style="color: #800000;">#Counter</SPAN></SPAN><SPAN style="font-size: 10pt;">; </SPAN></P><P><SPAN style="font-size: 10pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/175597_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt;">Antonio</SPAN></P></BODY></HTML> Tue, 05 Sep 2017 14:05:00 GMT antoniotiman 2017-09-05T14:05:00Z counter on SubField https://community.qlik.com/t5/QlikView/counter-on-SubField/m-p/1438925#M818187 <HTML><HEAD></HEAD><BODY><P>I have this table loaded:</P><P></P><P>Product, #Counter</P><P>iPhone X, 3</P><P>Samsung 8, 2</P><P></P><P>Now i want to ETL this to:</P><P></P><P>Product, #Counter</P><P>iPhone X 1, 1</P><P><SPAN style="font-size: 13.3333px;">iPhone X 2, 1</SPAN></P><P><SPAN style="font-size: 13.3333px;">iPhone X 3, 1</SPAN></P><P><SPAN style="font-size: 13.3333px;">Samsung 8 1, 1</SPAN></P><P><SPAN style="font-size: 13.3333px;">Samsung 8 2, 1</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">How can i do this?<BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/counter-on-SubField/m-p/1438925#M818187 amien 2020-11-25T16:16:04Z Re: counter on SubField https://community.qlik.com/t5/QlikView/counter-on-SubField/m-p/1438926#M818188 <HTML><HEAD></HEAD><BODY><P>Hi Amien,</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG style="font-size: 10pt;">LOAD</STRONG></SPAN><SPAN style="font-size: 10pt;"> <SPAN style="color: #800000;">Product</SPAN>&amp;' '&amp;<SPAN style="color: #0000ff;">IterNo</SPAN>(), 1 <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">#Counter</SPAN> <SPAN style="color: #0000ff;">Inline</SPAN> <SPAN style="color: #800000;">[<BR /> Product, #Counter<BR /> iPhone X, 3<BR /> Samsung 8, 2<BR /> ]</SPAN><SPAN style="color: #0000ff;">While</SPAN> <SPAN style="color: #0000ff;">Iterno</SPAN>() &lt;= <SPAN style="color: #800000;">#Counter</SPAN></SPAN><SPAN style="font-size: 10pt;">; </SPAN></P><P><SPAN style="font-size: 10pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/175597_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt;">Antonio</SPAN></P></BODY></HTML> Tue, 05 Sep 2017 14:05:00 GMT https://community.qlik.com/t5/QlikView/counter-on-SubField/m-p/1438926#M818188 antoniotiman 2017-09-05T14:05:00Z