Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to add the unique row number to each row ??????
In your load script use:
LOAD
RowNo() AS RowNumber
,Field1
,Field2
,etc
FROM...;
Jason
Hi,
use rowno()
Celambarasan
I used it but the output is coming 1 for each row ???????????
In your load script use:
LOAD
RowNo() AS RowNumber
,Field1
,Field2
,etc
FROM...;
Jason
Hi,
Where you have used?
Celambarasan