Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chrisk44
Contributor III
Contributor III

Renumering data

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:

 

IDDATE
11111999-02-15
11112008-09-24
22222002-06-20
22222002-06-20
33331996-01-02
33332008-07-16
33332018-11-30
44441998-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...:

IDDATERENUMBERED_ID
11111999-02-1511111
11112008-09-2411112
22222002-06-2022221
22222002-06-2022221
33331996-01-0233331
33332008-07-1633332
33332018-11-3033333
44441998-09-0144441

 

Thanks in advance.

2 Replies
santhiqlik
Creator
Creator

Hi,
Try this...

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

Hi all - i get answer in another thread:

 

ID & AutoNumber(DATE, ID) as RENUMBERED_ID

 

So simple - so efective 🙂

 

Thanks All

Regards