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...
Please share some sample data....
You can do like below in Preceding Load
AutoNumber(RowNo(), ID) as RowNo
Or Please try like this
LOAD * , RowNo();
LOAD * Inline [
You can use AutoNumber(RecNo(), ID) AS RowNo
Retrieving data ...