topic Re: Renumering data in QlikView

Renumering data

chrisk44 — Wed, 25 Nov 2020 16:16:04 GMT

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:

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...:

Thanks in advance.

santhiqlik — Wed, 13 Mar 2019 06:17:00 GMT

Hi,
Try this...

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

chrisk44 — Wed, 13 Mar 2019 22:56:06 GMT

Hi all - i get answer in another thread:

ID & AutoNumber(DATE, ID) as RENUMBERED_ID

So simple - so efective 🙂

Thanks All

Regards