How to use If activity to update specific column?

Hi Everyone,

I am new in UiPath community and I need help in updating a specified column.

For my case please see below:

Example:

If (“Column A”) = “Yes”

then

“Column B” = “Failed”

I tried to do it on my end but column B is not updating.

Thanks in advance!

can you upload the excel file and sequence?

Hi Jack,

For testing purposes we can use this link below:

Let me know thanks!!

result
image

sequence: (put TestFile.xlsx in the same folder as this)
test.xaml (8.2 KB)

  1. read range to read excel to datatable variable called dt
  2. use for each row to loop over dt - check if column A = “Yes”, if so, update column B = Failed
  3. write new table to TestFile.xlsx

Thank you very much!

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