Would appreciate some help.
I have an excel spreadsheet here that I have converted into a data table.
I have added a new column into the data table as “BAU or Backlog”
I want to see if Column L and Column N contains the value “Due” for every row in the data table.
If Column L = “DUE” and Column N = “DUE”, I want the value “Backlog” to be entered into the “BAU or Backlog” Column.
Can someone please advise how I can go about doing this.
At the moment my workflow looks like this
- Excel Application Scope
Read Range - Sheet 1 (output DT1)
- Add data column (columnName “BAU or Backlog”, DataTable = dt1)
- For each row ( row in dt1)
Get row item (column L) -> into a variable
Get row item (column N) -> into a variable
If condition variable = due and variable = due
This is where I’m unsure what activity to use to enter a value into the cells