Problem with Rowno()

[Anonymous]

Hi guys,

I'm facing issue to create rowno based on ID. Please check the below image for your reference what i'm expecting output

rowno should starts with 1 for every new ID.  Please help me out...

[prma7799]

Please share some sample data....

[Anil_Babu_Samineni · Accepted solution]

You can do like below in Preceding Load

AutoNumber(RowNo(), ID) as RowNo

[prma7799]

Or Please try like this

LOAD * , RowNo();

LOAD *  Inline [

Id,

1,

1,

1,

2,

2,

2,

3,

4

];

[daveamz]

Hi Siva,

You can use AutoNumber(RecNo(), ID) AS RowNo

Regards,

David