Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Highlighted
New 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
Contributor

Re: Renumering data

Hi,
Try this...

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

Re: Renumering data

Hi all - i get answer in another thread:

 

ID & AutoNumber(DATE, ID) as RENUMBERED_ID

 

So simple - so efective 🙂

 

Thanks All

Regards