Get only unique rows

[oliveiramauro (Mauro Oliveira)]

Hi,

I have an automation that extract a DataTable from a website and need to write to an Excel file, but i need to write only the unique rows based on a column. Example:

DT extracted from website

Name	Date
John	01/07/2022
John	01/05/2022
Abigail	01/02/2022

Output to excel file

Name	Date
Abigail	01/02/2022

Best regards.

[ppr (Peter)]

Give try in following

Assign Activity
Lhs: dtResult
Rhs

(From d in yourdatatablevar.asenumerable
Group d by k=d(yourcolnameorindex).tostring.trim Into grp=group
Where grp.Count=1
Select r=grp.first()).copytodatatable

[oliveiramauro (Mauro Oliveira)]

Thanks Peter, it worked just fine.