load *, rowno() as id inline [
Person, Job, Sequence
Bob, Exec10, 0
Chris, DevII, 0
Terry, Aux ,0
Tiffany ,Dev, 0
id, Person, Job,
peek(Sequence))) as Sequence
order by Person, Job;
DROP Table a;
Thanks, man! While i was waiting for a response, i've tried this
if(previous(Person)=Person and previous(Job)<>Job,numsum(Peek('Sequencia'),1),Peek('Sequencia'))) as Sequencia
But it didn't seem to work... after some search there was some trash in our data, f***ing the sequence.
Both yours and mine solution works now. Thanks for your attention!
It's always good to know that are more than one solution =)