Cumulative count in data load

[RyanProbyn]

Hi Qlik Community,

I have a table as follows:

ID	Catagory
1	a
2	b
2	c
3	a
3	b
3	c

I would like the following:

ID	Catagory	Cumalitive_count(id)
1	a	1
2	b	1
2	c	2
3	a	1
3	b	2
3	c	3

is there an easy way to do this in the dataload?

Cheers,

Ryan

[Ksrinivasan · Accepted solution]

hi,

try this in script,

hhhh:

LOAD
ID,
Catagory,
AutoNumber(RowNo(),ID) as Rank

result:

ksrinivasan

[RyanProbyn]

Works like a charm!

Many thanks,

Ryan