Skip to Content
0

Please see below text

Jun 14, 2017 at 01:08 PM

14

avatar image

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!!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers