I'm new to QV -and
I have a problem with renumbering rows in the database... Namely:
The source table looks like this:
| ID | DATE |
| 1111 | 1999-02-15 |
| 1111 | 2008-09-24 |
| 2222 | 2002-06-20 |
| 2222 | 2002-06-20 |
| 3333 | 1996-01-02 |
| 3333 | 2008-07-16 |
| 3333 | 2018-11-30 |
| 4444 | 1998-09-01 |
Ultimately, for each date change, you should generate a new ID number - new column based old one with ID and one in succession of 1, 2, 3 etc...:
| ID | DATE | RENUMBERED_ID |
| 1111 | 1999-02-15 | 11111 |
| 1111 | 2008-09-24 | 11112 |
| 2222 | 2002-06-20 | 22221 |
| 2222 | 2002-06-20 | 22221 |
| 3333 | 1996-01-02 | 33331 |
| 3333 | 2008-07-16 | 33332 |
| 3333 | 2018-11-30 | 33333 |
| 4444 | 1998-09-01 | 44441 |
Thanks in advance.
