Add an index number to data

[HarryC22]

Hi, I'm trying to add an index that increments by one for each change in customer:

My data

account_no
10545321
10545321
17735208
17735208
56193802
64266537
64266537
64266537

My desired result

account_no	index
10545321	1
10545321	1
17735208	2
17735208	2
56193802	3
64266537	4
64266537	4
64266537	4

Thanks!

[JosephSerpis]

Hi @HarryC22 you can use a multi-row tool for this to check the account number above and if the same use the same Index/rank number if it doesn't meet this criteria add 1. This can all be done in a condtional/IF formula in the Multi-Row tool.

[grazitti_sapna]

@HarryC22, you can use the tile tool to achieve the same.

Thanks!

[binu_acs]

@HarryC22 One way of doing this with the multi-row tool