Renumering data

[chrisk44]

Hello All.
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.

[santhiqlik]

Hi,
Try this...

Load
ID,
DATE,
Num(Text(ID) & Text(RowNo())) as RENUMBERED_ID
Resident table name;

[chrisk44]

Hi all - i get answer in another thread:

ID & AutoNumber(DATE, ID) as RENUMBERED_ID

So simple - so efective 🙂

Thanks All

Regards