Can We create a Variable in Mapper
Hello Everyone,
I am trying to create an incremental addition let say i have 2 columns empl_id and salary so in target i want to derive third column with cumulative salary.
I can do it by using v...
Forum Discussion
Hello,
I used the above functionality to implement RANK also.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.
I have got the code but its too many snaps and i want to simplify it.
Here is the pipeline and output:
SampleRankJob_2019_09_24 (2).slp (23.5 KB)
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
