Remove the duplicates in Excel based on two column values

[rlgandu (Rajyalakshmi Gandu)]

@Vineet_Joshi

[Parvathy (PS Parvathy)]

Hi @Vineet_Joshi

Remove the duplicates in Excel based on two column values

Hi @Vineet_Joshi → Read Range Workbook [image] Output-> InputDt → Use syntax in Assign: dtExtractedText = (From row In InputDt.AsEnumerable() Group row By Key = New With { Key .InvoiceNumber = row.Field(Of Object)("Invoice Number"), Key .SupplierNumber = row.Field(Of String)("Supplier Number") } Into Group Select Group.First()).CopyToDataTable() => Write Range Workbook dtExtractedText [imag…

Regards

[lrtetala (Lakshman Reddy)]

@Vineet_Joshi

Remove the duplicates in Excel based on two column values

Hi @Vineet_Joshi Try this [image] DataTable.AsEnumerable() _ .GroupBy(Function(row) New With { Key .InvoiceNumber = row.Field(Of Object)("Invoice Number"), Key .SupplierName = row.Field(Of String)("Supplier Name") }) _ .Select(Function(Group) Group.First()) _ .CopyToDataTable() Input: [image] Output: [image] Regards,

[Vineet_Joshi]

I have tried these queries but not working on my machine as I am using 2020.10.2.
I have used this and it is working now :
(From roww In DT.AsEnumerable() Group By id=New With {key .i=roww.item(“col1”),key .d=roww.item(“col2”)} Into gg=Group Select gg(0)).copytodatatable