Hello ,
I need to add the row number based on 2 fields in a table. Could you help please ?
table data : col1, col2 , col3
0, data 1 , adata1
0, data 1 , adata2
0, data 1 , adata3
0, data 1 , adata4
0, data 2 , adataX
0, data 2 , adata2
I want to update column1 by adding the row number for each different entry in column2 and column3
col1, col2 , col3
1,data 1 , adata1
2, data 1 , adata2
3, data 1 , adata3
4, data 1 , adata4
1, data 2 , adataX
2, data 2 , adata2