Seperating only unique rows from an excel based on company name

Test.xls (40.7 KB)


Can you please try this

DataTable FilterDt= MainDataTable.DefaultView.ToTable(true,“Company Name”)


1 Like


I have created workflow based on your requirement please run and check you will get the solution. (29.4 KB)

Hi @thima,

There can be two ways to get unique rows from an excel.

  1. Using function
  2. Using Excel formula

Please find both the workflows attached below. (20.4 KB)

1 Like

Hey @thima,

Try this

FilterDT = dt.AsEnumerable().GroupBy(Function(x) x.Field(Of String)(“Company Name”)).Select(Function(a) a.First).CopyToDataTable

Best Regards,