I am trying to group one datatable and after grouping I have to find the row with max date(latest date) and that resultant row I want to put in a separate datatable.
Please find attached picture.
Here, input datatable having 5+ columns .I want to group data with column “Contract Number”. After grouping I want to find row which having latest or Max date .
That all latest dates rows I want to add in another datatable for further process.
(in picure first DT is an Inout dt and second (output dt is what i want in result ))
Can anyone please help in this.