I am trying to implement the RANK function similar to what we have in sql. Rows with equal values for the ranking criteria should have the same ranks and ranks might not be consecutive numbers. For example, if two rows are ranked 1, the next rank is 3.
Here is the output I am expecting , I have attached the input pipeline. i have got the consecutive ranks but not able to figure out how to eliminate the ones which are same.
key name date rank
ABC Orange 8/1/2018 1
ABC Orange 10/1/2018 7
GEF Apple 10/1/2018 1
GEF Apple 11/1/2018 3
SampleRankJob_2019_09_24.slp (13.8 KB)