how to assign ranking to duplicate values?

[Akina0929]

hi,

  I have a field ID , that consist values like following,

ID

A

A

A

A

B

B

B

C

C

C;

   I want assign ranking to that field like

ID, Rank

A,1

A,2

A,3

A,4

B,1

B,2

B,3

C,1

C,2

C,3

please help me, how can i achieve

Thanking you,

[sunny_talwar]

May be this

LOAD ID,

           AutoNumber(RowNo(), ID) as Rank

FROM ...

[Anil_Babu_Samineni · Accepted solution]

Look here

LOAD ID, AutoNumber(RowNo(),ID) as Rank Inline [

ID

A

A

A

A

B

B

B

C

C

C];