Sum of rows and fill output into another column

Hi, @Soniya215,

  1. You can create a new column for the Total using “Add data Column” activity.
  2. Use For each row for the datatable and update the column value “Total” using assign activity.

row(“Total”) = Convert.ToString(Int32.Parse(Convert.ToString(row(“Column1”)))+Int32.Parse(Convert.ToString(row(“Column3”)))+Int32.Parse(Convert.ToString(row(“Column4”))))

At the end of the loop, you will have the datatable as required.

Happy Learning! :slight_smile: