Remove all duplicate occurrences

[niro]

Hello, the existing Remove Duplicate Rows activity removes the second duplicate occurrence keeping the first one. But I’m looking to delete both the occurrences that match the whole row, not just a specific column. Any linq queries will be helpful

[ppr (Peter Preuss)]

[HowTo] - Find Duplicate / NonDuplicate rows - checking all columns - without explicit listing the colnames/index

Introduction In the majority of scenarios duplicated / Non duplicated rows can be identified by a few columns grace to the key column concept. In order to retrieve it, the group by approach helps It can be done e.g. with some nice components from Connect or LINQ In some scenarios all duplicated / non duplicated rows should be detected by checking all columns. Setting up an approach without explicit listing all column names or column index would speed up the implementation. Implementat…

[niro]

The non duplicate rows was exactly what I was looking for. Thank you once again for helping