topic Re: Load script to populate unique row numbers in QlikView

Load script to populate unique row numbers

jduluc12 — Sat, 16 Nov 2024 01:07:15 GMT

Hi,

My data set looks like this.

I need to write a load script that adds a row# column to this table in the following manner.

The ROW# grows sequentially for the same ID and then restarts for each new ID as shown in the table above.

Thanks,

jochem_zw — Fri, 06 Mar 2020 06:12:10 GMT

Try Autonumber(ID)

jduluc12 — Fri, 06 Mar 2020 07:25:58 GMT

thanks for the answer but this may not work for me.

it autogenerates the ID in a sequence but I need to restart the number for a new ID the way I have shown in the second table.

tresB — Fri, 06 Mar 2020 07:44:42 GMT

Try using second parameter in autonumber() like:

Autonumber(RowNo(), ID) as Increment

Brett_Bleess — Thu, 02 Apr 2020 13:12:32 GMT

Just adding Help link to AutoNumber():

Regards,
Brett