I already know how to remove duplicate rows within a DT using the activity.
However, how do we do the opposite?
Where we keep only duplicated rows and delete all rows that do not have a duplicate?
Thanks in advance!
I already know how to remove duplicate rows within a DT using the activity.
However, how do we do the opposite?
Where we keep only duplicated rows and delete all rows that do not have a duplicate?
Thanks in advance!
@Sami_Syed
Alternate to the Join approach with a group by the duplicates can be detected as well
In general there are some Options/variations
A very important Info is about the duplicates:
In Case of you are interrested on one of the approaches Let US know.
I dont understand any of the code on that solution. Could you explain it please?
I would like to retrieve the duplicate rows comparing all columns in one data table? Any inputs