Need help in the below scenario. I have gone through all the help topics and could find an exact solution for the scenario.
My scenario is, I need to find the duplicate rows in the main datatable based on the “Subject” column and the keeping the 1st occurrences and other non-duplicates in the main datatable and move all the duplicates to another new datatable.
New Duplicate Datatable should look like this:
So once we moved the duplicate to the new datatable, the main data table should have the rows as shown below:
In otherwise I need to add a Column “Duplicate” and mark the duplicate rows as “Dup” keeping the first occurrence.
Anyone, please help.
Thanks in Advance.