How to create a ranking system in Jitterbit App Builder

At some point you may want to create a ranking system if you would like leaderboards or points associated with columns you want to display. An example is where you want to display Employees ranked by number of points they've generated by an activity.

If you want to create a ranking system in your {{nm.ab}} application, you will need to escape {{nm.ab}} and use SQL with the following syntax: ${RANK() OVER (ORDER BY {{Sum}} DESC)}. In this example, Sum is the column we want to sort by in the rank, and we indicate a descending order with DESC.

Resources

• For additional information see the Microsoft documentation for ROW_NUMBER (Transact-SQL)