generate row numbers graphically

[chaithu24]

i have 1000 duplicate records and i want to generate row number for 1000 records from 1-1000 and i want to concatenate these row numbers to my primary key column so i can get unique records

how can i achieve this graphically in Hana calculation view

[KonradZaleski]

For generating row number you can use the Rank node. Put Threshold as 1000 and select option Generate Rank Column. This will generate you additional column Rank_Column with the numbers from 1 to 1000.

[chaithu24]

Thank you konrad

[KonradZaleski]

If that answers your question, please accept it.