I'm making an extract and want to number rows with the same values to have same row number. Example :
TRN Date Product ROW_Number ABC1 2015-06-15 001 1 ABC1 2015-06-15 002 1 ABC1 2015-06-15 003 1 DEF1 2015-06-15 001 2 DEF1 2015-06-15 002 2
The rows with same TRN must have same row_number. Is this possible at all? If it can not be done in the script it's an option to do numbering in Deski, so if someone knows how I`ll be very thankful!