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

[Karunamurthy (Karunamurthy Narasimhan)]

I have situation where I have to delete duplicate information in an Excel file for two columns A and C (Member ID# and Last Name) using only Workbook activities. Excel application should not be used. Kindly help!

[Shiva_Nikhil]

@Karunamurthy

dt1.AsEnumerable.GroupBy(Function(a) Tuple.Create(a(0).ToString,a(2).ToString)).Select(Function(grp) grp.First).copytodatatable

Hope this helps

[copy_writes (chethan)]

@Karunamurthy

I have situation where I have to delete duplicate information in an Excel file for two columns A and C (Member ID# and Last Name) using only Workbook activities. Excel application should not be used. Kindly help!

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

How to delete duplicate rows in Excel

Hi Everyone. I need to delete duplicate rows in excel. But in that duplicate rows i need to keep one row.For example, in one column 3 more duplicate values is there. [Capture]

[Karunamurthy (Karunamurthy Narasimhan)]

Hi @copy_writes

I am getting the below error. Can you help?

[copy_writes (chethan)]

Change the type to double or in x.Field(Of String)(“Member ID#”)

I guess you are getting hear

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

[kali]

You can use default view.

dt_test.DefaultView.ToTable(true)
it makes your table distinct. See example