Multi-Row formula

[Sarath27]

If there is a same rank, then next rank should be increment of plus 1. For example, if there are two 1st Rank, then next one should be 3 rank. I have already used Multi-row formula for achieving attached results. Please assist me with this. Thanks in Advance.

[caltang]

Not sure what you mean exactly @Sarath27 - can you explain it more clearly and provide an expected output file + your data so that we can look at it?

Alternatively, if you can't share, try using the Tile Tool and Group By the Rank. Your tile_sequence_num should be what you want if I understand you correctly. Use a Select Tool thereafter to rename and choose the fields of your liking.

[flying008]

Hi, @Sarath27 

Maybe this is your want :

Input		Output
Rating		Rating	Tile_Num	Tile_SequenceNum
7		7	1	1
7		7	1	2
6		6	2	1
5		5	3	1
4		4	4	1
4		4	4	2
4		4	4	3
3		3	5	1
2		2	6	1
2		2	6	2
2		2	6	3
1		1	7	1

[Sarath27]

@flying008 @caltang I am trying to achieve Rank function in SQL.

 I able to figure out the solution. Thanks for your prompt response. Much appreciated.

[Qiu · Accepted solution]

@Sarath27 
That is exactly weekly challenge #122.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-122-Think-Like-a-CSE-Ranking-Data/td-p/1...😁