How to append the value in datatable of particular row

[Sudharsan_Ka]

HI @sruthesanju

As same like this expression i shared in your other post you just need to modify the value inside the quotes

Add same datatable

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 [image] [image] [image] Hope this helps! Regards S…

Use 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")+" as per source"}
Select Dt_Out.rows.add(result)).CopyToDataTable

Hope this Helps!

Regards
Sudharsan