Count and Serialize the duplicated value

[atsushi_saijo]

In a request, we have to count and serialize the duplicated values in such manner (see Col2):

Col1	Col2
a	1
b	1
a	2
a	3
c	1

Here, we have 3 duplicated rows in Col1. User's request is to count gradually as loading script goes. Perhaps it's like comparing value with Previous(Col1), and if so, sum....How could we achieve such count?

*To obtain the total duplicated count, it is rather easy to group by and count Col1. But if we had to count as loading script goes, I wonder what could be the possibility?

[Gysbert_Wassenaar · Accepted solution]

LOAD

     Col1,

     autonumber(recno(),Col1) as Col2

FROM ...

[atsushi_saijo]

Thank you for excellent and fast reply. It is verified working.