how to use mutli-row formula tool to generate sequential indexing

[AKPWZ]

This is my input data:

 And I want my final output should look like this, were I can generate sequential indexing for all duplicate json_index numbers.

Please help me with this. Thank you

[RishiK]

@AKPWZ have a look at the Tile tool which might help you generate the final_index for your data:

https://help.alteryx.com/2019.2/Tile.htm?TocPath=Tools%7CTool%20Categories%7CPreparation%7C_____18

[AKPWZ]

Hi, @RishiK thank you for the reply.

As a beginner I don't have much idea about this tool, I tried it but was unable to figure it out.

I'm still using the Multi-Row Formula tool to get my work done.

Here is the expression which I'm using it:

if [json_index] = [Row+1:json_index] or [json_index] = [Row-1:json_index] then
[Row-1:final_index]+1
else
[Row-1:final_index]
endif

but it's not working for me. please help me with this. Thank you!

[RishiK]

@AKPWZ is this expression to update the final_index field? I don't think you need the or part of the expression, ie can you try the below:

if [json_index] = [Row+1:json_index] then
[Row-1:final_index]+1
else
[Row-1:final_index]
endif

Another tip - you can use the Unique tool to identify your duplicates if that helps.