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