Updating 1 column if another column is blank

I have two columns in my data table. The first may be blank and if so i want to update second column to display “Yes”.

HI @jon1302

Try the below command and see whether it works


Let know how it goes for you

Additionally, in the assign, make you are updating the data table column. You are updating a variable. TO update do this

row("ColumnName") = "Yes"

Hi @jon1302,

Try making these changes

Later write to excel


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