Hi,
I'm trying to identify duplicates and keep the latest.
The file contains two columns.
First column is the Ticket_Id, which is unique.
Second column is the instancia, which can be duplicate.
third columns is where i want to identify the duplicates
Each time a instancia enters to the system it give a new ticket. The system allows to enter same instancia, but if will give a new ticket (with a highir Ticket Id number).
I would like to keep (mark as 1) the unique based on the ticket. And from the duplicates I would like to keep (or mark as 1) the unique base on its higher ticket, which means was the latest to enter to the system
Ticket_Id INSTANCIA unique
47483 401574944 1
47485 401574966 1
47486 401574972 0
52427 401574972 1
Sometime could be more that 2 duplicates (3, or 4)
Any help will be really appreciated it.
Thanks,
mils
Bookmarks