Linq Queries

Help
, ,
1

How to subtract two columns of same datatable and put the result in the same datatable to a new column?

1 Like
2

ForEach row In firstInputDT row(“Total”) = (CDbl(row(“Business Unit”).Tostring) - CDbl(row(“Quantity Ordered”).Tostring))
I used this query, it is not working for me…?

1 Like
3

@Manish540 In For each Row make sure both the columns have same Datatype , you cannot Subtract With Different Datatypes, Use Add Data Column Activity to add a new column then inside For each use a Add Data Row in a new table or Existing Table, if you are using New Table then Initialize

1 Like
4

Can you send me the sample query of it…