Rowno with aggr for grouping data

[Abbou]

Hi all
I have a table that have some fileds: Calendar,Ticket,Time (min) (sorted in ascending order)
I want to add row no for each Date like the sample bellow.
Important: I want to do this in the load script and not as an expression in a pivot or straight table.

[brunobertels]

Hi 

May be this in script 

load 

autonmumber(Calendar) as Rowno,

Calendar,

ticket, 

time 

from ...