For each row datatable, extract only the latest result

[Anil_G (Anil Gorthi)]

@Joanna2

Did you happen to try this

Datatable and click on the latest date

@Joanna2 Use the following and get the latest job ID Dt.AsEnumerable.Where(function(x) x("Parameter set").ToString.Equals("AsOf11monthsAgo")).OrderByDescending(function(x) DateTime.Parse(x("Starttime").ToString,"MMM dd, yyyy hh:mm:ss tt",System.Globalization.CultureInfo.InvariantCulture))(0)("JobID").ToString Now use the above job id as variable in the innertext property of the column Selector looks like this <webctrl tag='TD' tablecol='7' innertext='{{jobidvariable}}' /> Cheers

Cheers