Is there a way I could count and index number of time item appear in a list?
something like if first.item then count := 1; else count := count + 1; end if;
| item | count |
| a | 1 |
| a | 2 |
| a | 3 |
| b | 1 |
| b | 2 |
| c | 1 |
| c | 2 |
| c | 3 |
Is there a way I could count and index number of time item appear in a list?
something like if first.item then count := 1; else count := count + 1; end if;
| item | count |
| a | 1 |
| a | 2 |
| a | 3 |
| b | 1 |
| b | 2 |
| c | 1 |
| c | 2 |
| c | 3 |