topic Condtional SeqNo creation while loading from Excel in qlikview in QlikView https://community.qlik.com/t5/QlikView/Condtional-SeqNo-creation-while-loading-from-Excel-in-qlikview/m-p/717793#M257966 <HTML><HEAD></HEAD><BODY><P>Dear All, i am loading a DATA Like below </P><TABLE><TBODY><TR><TD>SrNo</TD><TD>Product</TD></TR><TR><TD>1</TD><TD>A</TD></TR><TR><TD>2</TD><TD>B</TD></TR><TR><TD>3</TD><TD>A</TD></TR><TR><TD>4</TD><TD>A</TD></TR><TR><TD>5</TD><TD>B</TD></TR><TR><TD>6</TD><TD>C</TD></TR><TR><TD>7</TD><TD>C</TD></TR><TR><TD>8</TD><TD>A</TD></TR></TBODY></TABLE><P></P><P>i required to add a extra column product SeqNo and result after load should be like below.. productwise seq No</P><P></P><TABLE><TBODY><TR><TD>SrNo</TD><TD>Product</TD><TD>ProductSeqNo</TD></TR><TR><TD>1</TD><TD>A</TD><TD>1</TD></TR><TR><TD>2</TD><TD>B</TD><TD>1</TD></TR><TR><TD>3</TD><TD>A</TD><TD>2</TD></TR><TR><TD>4</TD><TD>A</TD><TD>3</TD></TR><TR><TD>5</TD><TD>B</TD><TD>2</TD></TR><TR><TD>6</TD><TD>C</TD><TD>1</TD></TR><TR><TD>7</TD><TD>C</TD><TD>1</TD></TR><TR><TD>8</TD><TD>A</TD><TD>4</TD></TR></TBODY></TABLE><P></P><P>Please help.. want to do while loading script</P></BODY></HTML> Wed, 17 Sep 2014 10:12:47 GMT 2014-09-17T10:12:47Z Condtional SeqNo creation while loading from Excel in qlikview https://community.qlik.com/t5/QlikView/Condtional-SeqNo-creation-while-loading-from-Excel-in-qlikview/m-p/717793#M257966 <HTML><HEAD></HEAD><BODY><P>Dear All, i am loading a DATA Like below </P><TABLE><TBODY><TR><TD>SrNo</TD><TD>Product</TD></TR><TR><TD>1</TD><TD>A</TD></TR><TR><TD>2</TD><TD>B</TD></TR><TR><TD>3</TD><TD>A</TD></TR><TR><TD>4</TD><TD>A</TD></TR><TR><TD>5</TD><TD>B</TD></TR><TR><TD>6</TD><TD>C</TD></TR><TR><TD>7</TD><TD>C</TD></TR><TR><TD>8</TD><TD>A</TD></TR></TBODY></TABLE><P></P><P>i required to add a extra column product SeqNo and result after load should be like below.. productwise seq No</P><P></P><TABLE><TBODY><TR><TD>SrNo</TD><TD>Product</TD><TD>ProductSeqNo</TD></TR><TR><TD>1</TD><TD>A</TD><TD>1</TD></TR><TR><TD>2</TD><TD>B</TD><TD>1</TD></TR><TR><TD>3</TD><TD>A</TD><TD>2</TD></TR><TR><TD>4</TD><TD>A</TD><TD>3</TD></TR><TR><TD>5</TD><TD>B</TD><TD>2</TD></TR><TR><TD>6</TD><TD>C</TD><TD>1</TD></TR><TR><TD>7</TD><TD>C</TD><TD>1</TD></TR><TR><TD>8</TD><TD>A</TD><TD>4</TD></TR></TBODY></TABLE><P></P><P>Please help.. want to do while loading script</P></BODY></HTML> Wed, 17 Sep 2014 10:12:47 GMT https://community.qlik.com/t5/QlikView/Condtional-SeqNo-creation-while-loading-from-Excel-in-qlikview/m-p/717793#M257966 2014-09-17T10:12:47Z Re: Condtional SeqNo creation while loading from Excel in qlikview https://community.qlik.com/t5/QlikView/Condtional-SeqNo-creation-while-loading-from-Excel-in-qlikview/m-p/717794#M257967 <HTML><HEAD></HEAD><BODY><P>LOAD SrNo,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Product,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Autonumber(SrNo, Product) as <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">ProductSeqNo</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">From YourExcelFile.xls(x);</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">the result should be<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P></P><TABLE style="border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">SrNo</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">Product</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">ProductSeqNo</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">1</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">A</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">1</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">2</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">B</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">1</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">3</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">A</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">2</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">4</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">A</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">3</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">5</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">B</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">2</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">6</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">C</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">1</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">7</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">C</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;"><SPAN style="color: #ff0000;"><STRONG style="font-size: 12pt;">2</STRONG></SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">8</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">A</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px; font-style: inherit; font-family: inherit;">4</TD></TR></TBODY></TABLE><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">regards</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Marco<BR /></SPAN></P></BODY></HTML> Wed, 17 Sep 2014 10:15:16 GMT https://community.qlik.com/t5/QlikView/Condtional-SeqNo-creation-while-loading-from-Excel-in-qlikview/m-p/717794#M257967 MarcoWedel 2014-09-17T10:15:16Z Re: Condtional SeqNo creation while loading from Excel in qlikview https://community.qlik.com/t5/QlikView/Condtional-SeqNo-creation-while-loading-from-Excel-in-qlikview/m-p/717795#M257968 <HTML><HEAD></HEAD><BODY><P>PFA.</P></BODY></HTML> Wed, 17 Sep 2014 10:17:44 GMT https://community.qlik.com/t5/QlikView/Condtional-SeqNo-creation-while-loading-from-Excel-in-qlikview/m-p/717795#M257968 senpradip007 2014-09-17T10:17:44Z Re: Condtional SeqNo creation while loading from Excel in qlikview https://community.qlik.com/t5/QlikView/Condtional-SeqNo-creation-while-loading-from-Excel-in-qlikview/m-p/717796#M257969 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Wed, 17 Sep 2014 10:39:39 GMT https://community.qlik.com/t5/QlikView/Condtional-SeqNo-creation-while-loading-from-Excel-in-qlikview/m-p/717796#M257969 2014-09-17T10:39:39Z Re: Condtional SeqNo creation while loading from Excel in qlikview https://community.qlik.com/t5/QlikView/Condtional-SeqNo-creation-while-loading-from-Excel-in-qlikview/m-p/717797#M257970 <HTML><HEAD></HEAD><BODY><P>you're welcome</P><P>regards</P><P>Marco</P></BODY></HTML> Wed, 17 Sep 2014 10:48:47 GMT https://community.qlik.com/t5/QlikView/Condtional-SeqNo-creation-while-loading-from-Excel-in-qlikview/m-p/717797#M257970 MarcoWedel 2014-09-17T10:48:47Z