I've similar requirement but i need to reset ranking at each student level for each subject
101 - Maths -1
101 - Science-2
101 - English-3
102 - Science-1
102 - English-2
I tried with sequence but it continues ranking to all students instead of getting reset at each student. Can any of you tried this please let me know.
You can use Numeric.sequence in tMap to achieve your goal.
Please take a look at my screenshots for details
Let us know if it is OK with you.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Learn how and why companies are moving to the Cloud