Hello, everyone.
I need to add column in load script with running total for each unique value:
Country | Values |
Usa | 1 |
Germany | 1 |
France | 1 |
Italy | 1 |
Italy | 1 |
Germany | 1 |
With result:
Country | Values | Running total |
Usa | 1 | 1 |
Germany | 1 | 1 |
France | 1 | 1 |
Italy | 1 | 1 |
Italy | 1 | 2 |
Germany | 1 | 2 |
Appreciate your help very much, cause don't know how to do that.
Thanks!