Hi, I have an excel, need to filter the data based on the same date values in one of the columns.
Below attached is the sample:
Here I need to filter out the data and get the sum of data on the base of the same date and account number in the first column As of the date and second column Account number.
Need the output as:
Give a try on (quick Prototype handling Date on String Base):
assign1:
dtResult =dtData.Clone
Assign2:
(From d in dtData As Enumerable
Group d by k1=d(0).toString.Substring(0,11), k2=d(1).toString.Trim into grp=Group
Let s = grp.Sum(Function (x) CDbl(x(2).toString.Trim))
Let ra = new Object(){k1,k2,s,grp.First()(3)}
Select dtResult.Rows.Add(ra)).CopyToDataTable