Arguments/Filter for RemoveDuplicateRows

[mkkajtez (Miso)]

Activity: UiPath.Core.Activities.RemoveDuplicateRows

Currently the activity takes the entire data table and removes duplicates based off of all columns. It would be helpful if you could also specify which columns you want to check and remove the entire row based off just a few columns matching.

[bcorrea (Bruno Correa)]

See about this here:

Isolate multiple rows with duplicate column values

@Hisuhong find attached sample seperating the Duplicates and NonDuplicates and writes out into 2 different Worksheets Hisuhong.xaml (10.0 KB) Result for Reference: Result.xlsx (9.1 KB) the main Ideas were to Identify the Duplicates / NonDuplicates on its occurence validating the 4 columns this was solved with using the Keys for a GroupBy and Count E.g. NonDuplicates: (From r In dtOrigin.AsEnumerable() Select C1 = r(0).ToString.Trim, C2 = r(1).ToString.Trim, C3 = r(2).ToString.Trim, C4 =…