I need logic for this excel activity, I need to add all debit values of 1-Sep then for 2-sep I need add all the debit value belong to this date,,,So on

in general you can do it by a groupby

Build datatable activity, configure an empty datattable with 2 cols: ValueDate, Sum - dtResult

Assign activity
LHS: dtResult
RHS:

(From d in YourDataTableVar.AsEnumerable
Group d by k=d("VALUE DATE").toString.Trim into grp=Group
let ds = grp.Sum(Function (x) CDbl(x("DEBITS").toString.Trim))
Let ra =new Object(){k,ds}
Select r=dtResult.Rows.Add(ra)).CopyToDataTable

it could be the case that we have to handle the grouping key differently. This depends on values present in the datatable after reading the excel (Could be the case that it will be 09/01/2021 00:00:00). You can check it while debuging e.g. in immediate panel.

Also have a look here:

Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

1 Like