Feed data

Help
1

Hi There

I’m working on an automation project in which I need to feed data from an excel into an application on Citrix, need to process only those rows where value in “Status” column is NULL, also need to update the “Status” column as Pass or Fail after the data for the specific row is uploaded into the application.

Can someone help with the solution please.

Regards

VK

2
  1. use a read range activity to get a datatable
  2. use a for each row activity to iterate through the datatable
  3. use an if activity with the following condition row(a).isNullOrNothing where a is the index of the column
  4. use a write cell activity to write inside the excel