How to use If activity to update specific column?

Help Activities
, , ,
1

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!

2

can you upload the excel file and sequence?

3

Hi Jack,

For testing purposes we can use this link below:

Let me know thanks!!

4

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
    image
    image640×849 19.9 KB
  3. write new table to TestFile.xlsx
5

Thank you very much!

6

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