Changing a row of a datatable iwth a given condition


#1

Hi,
I am facing issue in updating a data table.

  1. I am reading data table and assigning each row to a variable(row). For each activity
  2. Now checking each value of the row by getting value as(row.item(postion(0,1,2…)
  3. Once column if the value is in some range then update the next column to some value
  4. At the end I am writing the data table to excel and sending it in attachment email.

Now the issue I am facing is not able to update the column value on the given condition.

Can someone advise me on this


#2

You can use assign activity to update the column data
if(row(“ID”).tostring =“10”)
{
//Use assign activity
row(“Salary”) = “2000”
}


#3

This might help you -