Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Pedro_Rodriguez
Contributor III
Contributor III

Number rows by dimension

Hi everyone,

I have a table with a Dimension and a value:

 

DimensValue
A3
A3453
A34
A324
B234
B8
C7
C54
C3

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.

 

RowDimensValue
1A3
2A3453
3A34
4A324
1B234
2B8
1C7
2C54
3C3

Thanks a lot in advance

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

Load

          *,

          AutoNumber(RowNo(), Dimens) as Row

View solution in original post

2 Replies
tresesco
MVP
MVP

Try like:

Load

          *,

          AutoNumber(RowNo(), Dimens) as Row

Pedro_Rodriguez
Contributor III
Contributor III
Author

Thanks a lot, works perfectly!!!