row number

[#1]

How to add the unique row number to each row ??????

[CELAMBARASAN]

Hi,

     use rowno()

Celambarasan

[#3]

I used it but the output is coming 1 for each row ???????????

[Jason_Michaelides · Accepted solution]

In your load script use:

LOAD

     RowNo()     AS     RowNumber

     ,Field1

     ,Field2

     ,etc

FROM...;

Jason

[CELAMBARASAN]

Hi,

     Where you have used?

Celambarasan