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
Output to excel file
Give try in following
(From d in yourdatatablevar.asenumerable
Group d by k=d(yourcolnameorindex).tostring.trim Into grp=group
Thanks Peter, it worked just fine.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.