Sql Sum query for datatable in uipath

Hi Team,

Am trying to write a query to calculate sum of quantity based on where clauses…

for item in array:
"select sum(Qty) from t1 where col1 = 'A' and col2 = "+item

How do i convert this to uipath style?

@hss Caan you Check with this Expression :

DT.AsEnumerable.Where(Function(x)x(“col1”).ToString.Equals(“A”) and x(“col2”).ToString.Equals(item.ToString)).Sum(Function(a)Convert.ToDouble(a(“Qty”).ToString))


Thanks @supermanPunch that worked :slight_smile:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.