Skip to Content
avatar image
Former Member

Please see below text

Hello. I need to add consecutive numbers to a new field in a HANA Calc View based on *unique* values of another field.

So if field 'A' has the following:

2000112
2000112
2000113
2000113
2000113

Then the field to update, after running the SQL, would have:

1
2
1
2
3

So basically I want to add a numeric, consecutive sequence that starts over with each unique value of another field. Can this be done using HANA SQL statement in HANA Studio? Please provide the SQL if so. Thanks!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers