Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
LOAD
Col1,
autonumber(recno(),Col1) as Col2
FROM ...
LOAD
Col1,
autonumber(recno(),Col1) as Col2
FROM ...
Thank you for excellent and fast reply. It is verified working.