Change of case ID in a bulk

Dear users,
in my dataset, I would like to simplify the case ID attribute.
My data is from ticketing system and sorted as each row = a status change within the case (ticked). This means, each case ID is the same for 2 - 7 rows depending on the complexity of the case (ticket).
At the moment, the case ID is quite complicated and I would like to replace it with simple numbers 1, 2, 3 etc.
This means, everytime the case ID changes (provided the dataset is sorted by case ID), new number in the line 1, 2, 3… would be generated. Example:

Current case ID Desired case ID
abC0062_AT(02) 1
abC0062_AT(02) 1
abC0062_AT(02) 1
abC0062_AT(02) 1
dkjerd_ABCD963 2
dkjerd_ABCD963 2

Please, how to do it in a bulk? I have a feeling that loops could help but I am not experienced enough.
Thank you so much.

Hi @versatilka

This can be achieved by using the Rank node.

gr. Hans


Hi @HansS so simple that is??
Thank you!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.