Sql Sum query for datatable in uipath

Help
,
1

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?

2

@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))

2 Likes
3

Thanks @supermanPunch that worked :slight_smile:

1 Like
4

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