How to delete duplicate rows in an Excel file by using only Workbook activities

Help Studio
, , , , ,
3

Read the excel data and use the below LINQ

// Assuming 'dt' is your DataTable
dt = dt.AsEnumerable().GroupBy(Function(x) New With {
    Key .MemberID = x.Field(Of String)("Member ID#"),
    Key .LastName = x.Field(Of String)("Last Name")
}).Select(Function(g) g.First()).CopyToDataTable()

Or You can use Filter activity.

or you can follow below