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
@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
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!
@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.