Iterate through columns in a datatable

Help Studio
, ,
6

e.g. with a Linq approach
Flow:

The image shows a sequence of data table operations in a workflow, specifically cloning a DataTable and then performing a LINQ query on it, with variable definitions for dtData and dtResult. (Captioned by AI)
The image shows a sequence of data table operations in a workflow, specifically cloning a DataTable and then performing a LINQ query on it, with variable definitions for dtData and dtResult. (Captioned by AI)730×350 30 KB

LINQ:

(From d In dtData.AsEnumerable()
Group d By k=d("debit acc").toString.Trim Into grp=Group
Let sum = grp.Sum(Function (c) CDbl(c("debit amount")))
Let ra = New Object(){k,sum}
Select r = dtResult.Rows.Add(ra)).CopyToDatatable

Check:

grafik
grafik220×282 15.3 KB