Row number based on groups of data

[Aditya_Chitale]

Hi All,

I want to assign same row number to groups of data in a table in load script based on grouping of field: "Name"

Desired Output:

Name	Date	Sales	Rowno
A	10-Dec-22	100	1
A	11-Dec-22	200	1
A	12-Dec-22	300	1
B	10-Nov-22	400	2
B	11-Nov-22	500	2
C	10-Nov-22	600	3

Regards,

Aditya

[tresesco · Accepted solution]

Try like:

Load Name, Date, Sales, Autonumber(Name)  as  Rowno From <>;