MaxValDT.xaml (7.4 KB) I need to get max value in a column based on Group by of two columns in datatable
From the Source Datatable, I need to get max values of column “Col 3” (found as string in SourceDT) based on Group by columns “Col 1” and “Col 2” in a new datatable. And “Col 4” is misc data.
Please help me to solve this.
What I have:
What I need:
In a New Datatable (DT1):
Since dealing with datatable with large data, I am trying in LinQ Query instead of For Each loop:
Please help me