Sequence Numbers


Probably a simple one, but I'm wanting to create sequence numbers across my data.

What I have is:

  • Customers sorted by ID number
  • Each customer is then sorted by a date/time attribute, from oldest to newest (most customers exist over multiple rows)

What I want to do is populate a sequence number against each row per customer to indicate first activity to last, and then to default back to 1 for each new customer.

Is there a node that does this, or a java approach?

Thanks in advance


There is a previous post that may help you at least partially......