Difference of two columns

Help Automation Ops
,
1

how to subtract two columns when the garbage values are getting and other columns are overwriting the column

2

Hi @anjani_priya

Provide the input file and required output.

If you want to subtract two column try the below one,

→ Use read range workbook activity to read the excel and store in a datatable.
→ Use for each row in datatable activity to iterate the each row in the datatable.
→ Insert an assign activity inside for each and give the below expression.

row("ResultColumn") = Convert.ToInt32(row("Column1")) - Convert.ToInt32(row("Column2"))

→ Outside of for each use write range workbook activity to write the datatable to excel.

Hope it helps!!

3

Hi @anjani_priya

Check the solution

Forum.zip (154.4 KB)

4

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