Add a new column in the script

[#1]

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?

[ramoncova06]

do you mean something like using rowno ?

load

*,

Rowno() as RowNumber

from table.qvd