Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
do you mean something like using rowno ?
load
*,
Rowno() as RowNumber
from table.qvd