Add all values in a column of a data table

[dla (David Laosa)]

Hi my friends,

¿Is there any way to add all the values of a column of a Data Table obtained after a Read Range Activity, and assing the result into a variable?

Thanks in advance!

[ppr (Peter Preuss)]

we can do (add by the understanding of value retrieval):
arrValues =
YourDataTableVar.AsEnumerable.Select(Function (x) x(YourColNameIrIndex).ToString).toArray

it will return us a string array and will work when the datatype of the data column is a simple datatype as string, int32, double…

About LINQ have a look here as well:

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…

[ushu (Usha kiranmai)]

Hello @dla - How about below expression

Variable of type double Output = DT.AsEnumerable.Sum(Function(x) Cdbl(x("Price")))

• Replace DT with your data table name
• Replace Price with your actual column name

Reference code - Example.zip (10.2 KB)

[RajKumar_DC (RajKumar Durai)]

Hi @dla ,

if you want to add column value plz check below workflow

ColumnValueAddToDataTable.xaml (10.1 KB)

Thanks,
Raj

[dla (David Laosa)]

Thank you a lot, it works!!

[dla (David Laosa)]

Thank you a lot!!

It`s also a soltion. I appologize I can only mark one answer as a solution.