Number rows by dimension

[Pedro_Rodriguez]

Hi everyone,

I have a table with a Dimension and a value:

Dimens	Value
A	3
A	3453
A	34
A	324
B	234
B	8
C	7
C	54
C	3

What I want to get is a new RowNo() Column numbering the rows by Dimension value so it gets like this:

I need to do it by scripting to generate a QVD.

Row	Dimens	Value
1	A	3
2	A	3453
3	A	34
4	A	324
1	B	234
2	B	8
1	C	7
2	C	54
3	C	3

Thanks a lot in advance

[tresesco · Accepted solution]

Try like:

Load

          *,

          AutoNumber(RowNo(), Dimens) as Row

[Pedro_Rodriguez]

Thanks a lot, works perfectly!!!