Add an index number to data

Question

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

My data

account_no1054532110545321177352081773520856193802642665376426653764266537

My desired result

account_noindex105453211105453211177352082177352082561938023642665374642665374642665374

Thanks!

Raw Data.xlsx

binu_acs · Answer

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

Multi_Row_12_07.yxmd

grazitti_sapna · Answer

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

Thanks!

HarryC22_workflow.yxmd

JosephSerpis · Answer

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.

Multi_Row_12072022.yxmd