The rank would be part of the named query.
Alternatively:
- Add a custom property called rawData
- Bind rawData to the named query
- add a propertyChanged script
if event.propertyName == 'rawData':
rawData = event.source.rawData
headers = list(rawData.getColumnNames())
data = []
for i in range(rawData.getRowCount()):
data.append(['{}-{}'.format(i+1, rawData.getValueAt(i,0)), rawData.getValueAt(i,1)])
event.source.data = system.dataset.toDataSet(headers, data)
