Seperating only unique rows from an excel based on company name

Help
1

Test.xls (40.7 KB)

2

@thima

Can you please try this

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

Thanks,
Aman

1 Like
3

@thima

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

UniqueRows.zip (29.4 KB)

4

Hi @thima,

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

  1. Using VB.net function
  2. Using Excel formula

Please find both the workflows attached below.

UniqueRows_135227.zip (20.4 KB)

1 Like
5

Hey @thima,

Try this

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

Best Regards,
SP