Incremental Record Id based on group level

[alt_tush]

Hi,

I have below data 

DEPT

HR

HR

HR

IT

IT

IT

IT

ADMIN

ADMIN

I want below expected output where RecordId column value inremented by 1 based on group level of Dept

Expected output :-

DEPT	RecordId
HR	1
HR	2
HR	3
IT	1
IT	2
IT	3
IT	4
ADMIN	1
ADMIN	2

Thank you,

[Felipe_Ribeir0 · Accepted solution]

Hi @alt_tush 

You can use the tile tool to do it

[alt_tush]

Thank you for your prompt reply :)