topic Re: Add Order Position to a table in the LOAD skript depending on orderid in QlikView https://community.qlik.com/t5/QlikView/Add-Order-Position-to-a-table-in-the-LOAD-skript-depending-on/m-p/1614152#M596867 <P>Hello Anil_Babu_Samineni,</P><P>that worked perfectly. Thanks you very much for your help!</P><P>Best wishes from Germany,</P><P>&nbsp;</P><P>Hermann</P> Tue, 20 Aug 2019 07:08:19 GMT hbuchetmann 2019-08-20T07:08:19Z Add Order Position to a table in the LOAD skript depending on orderid https://community.qlik.com/t5/QlikView/Add-Order-Position-to-a-table-in-the-LOAD-skript-depending-on/m-p/1612450#M596865 <P>Hello together,</P><P>&nbsp;</P><P>i am looking for a solution to the following problem.</P><P>I have a table which i load via skript:</P><TABLE><TBODY><TR><TD>OrderId</TD><TD>ArtikelNR</TD><TD>OrderItemQuantity</TD></TR><TR><TD>3811</TD><TD>8000100</TD><TD>1</TD></TR><TR><TD>3811</TD><TD>2354003</TD><TD>2</TD></TR><TR><TD>3811</TD><TD>2354011</TD><TD>4</TD></TR><TR><TD>3811</TD><TD>2354009</TD><TD>1</TD></TR><TR><TD>3811</TD><TD>2354014</TD><TD>2</TD></TR><TR><TD>3811</TD><TD>2354474</TD><TD>2</TD></TR><TR><TD>3811</TD><TD>2354010</TD><TD>2</TD></TR><TR><TD>3811</TD><TD>2354000</TD><TD>2</TD></TR><TR><TD>3811</TD><TD>2354012</TD><TD>4</TD></TR><TR><TD>3812</TD><TD>6221750</TD><TD>10</TD></TR><TR><TD>3812</TD><TD>8000100</TD><TD>1</TD></TR><TR><TD>3815</TD><TD>8000100</TD><TD>1</TD></TR><TR><TD>3815</TD><TD>1231986</TD><TD>5</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Now i need to add an Order Position (Field OrderPos) through the skript LOAD statement&nbsp; depending on the OrderID, always counting up by 1 starting from 1.</P><P>&nbsp;</P><P>This should be the result:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>OrderId</TD><TD>OrderPos</TD><TD>ArtikelNR</TD><TD>OrderItemQuantity</TD></TR><TR><TD>3811</TD><TD>1</TD><TD>8000100</TD><TD>1</TD></TR><TR><TD>3811</TD><TD>2</TD><TD>2354003</TD><TD>2</TD></TR><TR><TD>3811</TD><TD>3</TD><TD>2354011</TD><TD>4</TD></TR><TR><TD>3811</TD><TD>4</TD><TD>2354009</TD><TD>1</TD></TR><TR><TD>3811</TD><TD>5</TD><TD>2354014</TD><TD>2</TD></TR><TR><TD>3811</TD><TD>6</TD><TD>2354474</TD><TD>2</TD></TR><TR><TD>3811</TD><TD>7</TD><TD>2354010</TD><TD>2</TD></TR><TR><TD>3811</TD><TD>8</TD><TD>2354000</TD><TD>2</TD></TR><TR><TD>3811</TD><TD>9</TD><TD>2354012</TD><TD>4</TD></TR><TR><TD>3812</TD><TD>1</TD><TD>6221750</TD><TD>10</TD></TR><TR><TD>3812</TD><TD>2</TD><TD>8000100</TD><TD>1</TD></TR><TR><TD>3815</TD><TD>1</TD><TD>8000100</TD><TD>1</TD></TR><TR><TD>3815</TD><TD>2</TD><TD>1231986</TD><TD>5</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>It sounds simple, but sadly i cannot come up with a solution myself.</P> Wed, 14 Aug 2019 13:48:20 GMT https://community.qlik.com/t5/QlikView/Add-Order-Position-to-a-table-in-the-LOAD-skript-depending-on/m-p/1612450#M596865 hbuchetmann 2019-08-14T13:48:20Z Re: Add Order Position to a table in the LOAD skript depending on orderid https://community.qlik.com/t5/QlikView/Add-Order-Position-to-a-table-in-the-LOAD-skript-depending-on/m-p/1613502#M596866 <P>Perhaps this?</P><P><STRONG>Load OrderID, <FONT color="#FF0000">AutoNumber(Rowno(), OrderID) as OrderPos</FONT>, ArtikelINR, OrderItemQuanity From Source;</STRONG></P> Sat, 17 Aug 2019 14:15:55 GMT https://community.qlik.com/t5/QlikView/Add-Order-Position-to-a-table-in-the-LOAD-skript-depending-on/m-p/1613502#M596866 Anil_Babu_Samineni 2019-08-17T14:15:55Z Re: Add Order Position to a table in the LOAD skript depending on orderid https://community.qlik.com/t5/QlikView/Add-Order-Position-to-a-table-in-the-LOAD-skript-depending-on/m-p/1614152#M596867 <P>Hello Anil_Babu_Samineni,</P><P>that worked perfectly. Thanks you very much for your help!</P><P>Best wishes from Germany,</P><P>&nbsp;</P><P>Hermann</P> Tue, 20 Aug 2019 07:08:19 GMT https://community.qlik.com/t5/QlikView/Add-Order-Position-to-a-table-in-the-LOAD-skript-depending-on/m-p/1614152#M596867 hbuchetmann 2019-08-20T07:08:19Z