Web Data scraping and select the cloumn with earliest date

it is about LINQ

Just us an assign activity
grafik

LeftSide: DTCompanyOldestRows - a variable of DataType: DataTable
RightSide:

(From d In YourDataTableVar.AsEnumerable
Group d By k=d("Name").toString.Trim Into grp=Group
Let dro = grp.OrderBy(Function (x) CDate(x("Date").toString.Trim)).First()
Select r = dro).CopyToDataTable

YourDataTableVar = use the VariableName of your extracted Datatable