Assign an incrementing ID value

[Deano478]

Hi guys,

I have data like so:

ReturnType	ReturnStatus
CR	Sent
CR	Not Yet Sent
CR	Received
CB	Submitted
CB	In Progress
CB	Sent
CT	Rejected
CT	Return Filed
CT	Refund Pending
CT	New Info needed
CT	Rejected

What Im trying to do is assign a group ID to each Return Type. I've tried a few different methods but sadly no dice.

The output I'm trying to achieve looks like so:

ID	ReturnType	ReturnStatus
1	CR	Sent
1	CR	Not Yet Sent
1	CR	Received
2	CB	Submitted
2	CB	In Progress
2	CB	Sent
3	CT	Rejected
3	CT	Return Filed
3	CT	Refund Pending
3	CT	New Info needed
3	CT	Rejected

Many thanks in advance

[messi007 · Accepted solution]

@Deano478,

Please see below how you can do that.

Attached the workflow,

Regards

[Deano478]

@messi007  many thanks, I see what you did there i was just completely over thinking how to do it.

[messi007]

@Deano478,

Happy to help!

Regards,

[binu_acs · Accepted solution]

@Deano478 Another option is use the tile tool