Add same datatable

[Sudharsan_Ka]

HI @sruthesanju

Checkout this expression

(From row In Dt_inp.AsEnumerable
Group row By sc = row("Type").ToString()
Into grp = Group
Let total= grp.sum(Function (x) Convert.ToDouble(System.Text.RegularExpressions.Regex.Match(x("Reason").ToString,"\d+\.\d+").ToString))
Let type=grp(0)("Type").ToString
Let result = New Object() {type, "Amount is "+CDec(total).ToString("F1")+" for type "+type}
Select Dt_Out.rows.add(result)).CopyToDataTable

Hope this helps!

Regards
Sudharsan