within an expression I need to autonumerate rows in a way that new Name restarts counter
use the example code below
LOAD * INLINE [
IF (peek('name')<>name,1, peek('counter')+1) AS counter
order by name;
drop table Temp1;
Hi Przemek :-)
thanks for the reply. The problem, however, is that I need to have it built within an expression not script.
You could use similar approach, however that would only work when the names are sorted.
I can't think of a possible workaround at the moment (without having the names sorted).
Retrieving data ...