Removing duplicate row in datarowcompare

[ppr (Peter Preuss)]

@brindhaS
Have a Look Here.

Linq query to identify duplicates and delete both entries

@Charmaine_Matsaudza Welcome to the forum find following starter help implementing different scenarios find duplicates by 1 key column find non duplicates by 1 key column find duplicates by 1 Key column and keep first from duplicates + non duplicates FindDupsUniquesFirstFromGroup_By1Col.xaml (8.0 KB)

Maybe you will Just extend to the Second column but running with the Same logic