topic Add a new column in the script in QlikView https://community.qlik.com/t5/QlikView/Add-a-new-column-in-the-script/m-p/831897#M471176 <HTML><HEAD></HEAD><BODY><P><BR />I am trying to add a column to a table in the script to add a distinct value so I can show all lines in a table box. I am thinking of adding a column with numbers 1,2,3,4... how do I do that in the script?</P></BODY></HTML> Tue, 31 Mar 2015 17:58:51 GMT 2015-03-31T17:58:51Z Add a new column in the script https://community.qlik.com/t5/QlikView/Add-a-new-column-in-the-script/m-p/831897#M471176 <HTML><HEAD></HEAD><BODY><P><BR />I am trying to add a column to a table in the script to add a distinct value so I can show all lines in a table box. I am thinking of adding a column with numbers 1,2,3,4... how do I do that in the script?</P></BODY></HTML> Tue, 31 Mar 2015 17:58:51 GMT https://community.qlik.com/t5/QlikView/Add-a-new-column-in-the-script/m-p/831897#M471176 2015-03-31T17:58:51Z Re: Add a new column in the script https://community.qlik.com/t5/QlikView/Add-a-new-column-in-the-script/m-p/831898#M471177 <HTML><HEAD></HEAD><BODY><P>do you mean something like using rowno ?</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">load</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">*,<BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Rowno() as RowNumber </SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">from table.qvd</SPAN></P></BODY></HTML> Tue, 31 Mar 2015 19:11:50 GMT https://community.qlik.com/t5/QlikView/Add-a-new-column-in-the-script/m-p/831898#M471177 ramoncova06 2015-03-31T19:11:50Z