I would like to count the row count of the distinct value like the following table:
A 3A 4
C 2C 3
I have googled abt RangeCount function but I don't think it can serve my purpose.
Is there any method I can use for this calculation?
Try this code:
LOAD * INLINE [
if(RowNo()=0 or ID<>Peek(ID),1,Peek(Count)+1) as Count
Order by ID;
Drop Table Temp;
Or like this
AutoNumber(RowNo(), ID) as Count
Retrieving data ...