I'm trying to implement a new column. This column needs to presentate the rownumber, but it needs te be reset when a other field is changing.
ID Name Row
1 Peter 1
2 Peter 2
3 Peter 3
4 Erik 1
5 Erik 2
Check the example above. The rownumber in the column Row is resetting when the value in the field Name is changing.
What i did:
I added a sequence and tried to reset this sequence in a reformat component:
$out.0.Counter = sequence(Activiteit_Telling).reset();
Where do i need to tell the sequence it have to reset on the name field?