Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
Load
*,
AutoNumber(RowNo(), Dimens) as Row
Thanks a lot, works perfectly!!!